View: PAY_EMP_HRS_RATE_ACTION_INFO_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_EMP_HRS_RATE_ACTION_INFO_V

View Text

SELECT PAI.ACTION_CONTEXT_ID
, PAI.ACTION_INFORMATION1 ELEMENT_TYPE_ID
, PAI.ACTION_INFORMATION4 ELEMENT_NAME
, PAY_US_EMPLOYEE_PAYSLIP_WEB.GET_FORMAT_VALUE( PAF.BUSINESS_GROUP_ID
, PAI.ACTION_INFORMATION5) RATE
, PAY_US_EMPLOYEE_PAYSLIP_WEB.GET_FORMAT_VALUE( PAF.BUSINESS_GROUP_ID
, PAI.ACTION_INFORMATION6) HOURS
, PAI.ACTION_INFORMATION7 PROCESSING_PRIORITY
, PAI.ACTION_INFORMATION8 MULTIPLE
, PAY_US_EMPLOYEE_PAYSLIP_WEB.GET_FORMAT_VALUE( PAF.BUSINESS_GROUP_ID
, (PAI.ACTION_INFORMATION5 * PAI.ACTION_INFORMATION6 * PAI.ACTION_INFORMATION8)) AMOUNT
FROM PAY_ACTION_INFORMATION PAI
, PER_ASSIGNMENTS_F PAF
WHERE PAI.ACTION_INFORMATION_CATEGORY = 'EMPLOYEE HOURS BY RATE'
AND PAF.ASSIGNMENT_ID = PAI.ASSIGNMENT_ID
AND PAI.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE

Columns