Get the Rate Amount for an Assignment Base Rate

To get the rate amount for a specific rate of the salary, use the GET_SALARY_RATE_DATA function. You can use this function in payroll processing and to interface with other internal and external apps.

For payroll processing, you can use the rates-based ORA_CMP_ASSIGNMENT_SALARY_RATES_UE and ORA_CMP_ASSIGNMENT_SALARY_RATES_RGE_UE user entities to extract rate-based salary components for a particular date or date range.

Parameters

Parameter	Data Type	Comments
P_BASE_RATE_NAME	TEXT	Name of the base rate given in the rate definition, to get the rate amount
P_AMOUNT_TYPE	TEXT	If the input value is null or RATE_AMOUNT, returns the rate amount If the input value is ANNUAL_AMOUNT, returns the annual amount for the rate If the input value is ANNUAL_FT_AMOUNT, returns the annual full-time amount for the rate If the input value is RATE_FACTOR, returns the factor for the rate