View: PAY_US_REPORT_AS_OF_DATE_V

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

View Text

SELECT PAA.TAX_UNIT_ID TAX_UNIT_ID
, HOU.BUSINESS_GROUP_ID
, HOU.ORGANIZATION_ID ORGANIZATION_ID
, HOU.NAME ORGANIZATION_NAME
, PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, PPF.PERSON_ID PERSON_ID
, PPF.FULL_NAME FULL_NAME
, PAF.ASSIGNMENT_ID ASSIGNMENT_ID
, PAF.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, PPA.EFFECTIVE_DATE EFFECTIVE_DATE
, PPA.DATE_EARNED DATE_EARNED
, PPA.ACTION_TYPE ACTION_TYPE
, PAF.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PAF.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
FROM PAY_ASSIGNMENT_ACTIONS PAA
, PER_ASSIGNMENTS_F PAF
, PER_PEOPLE_F PPF
, PAY_PAYROLL_ACTIONS PPA
, HR_ORGANIZATION_UNITS HOU
WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PAA.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID
AND PAF.PERSON_ID = PPF.PERSON_ID
AND HOU.ORGANIZATION_ID = PAF.ORGANIZATION_ID
AND PPA.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND PPA.EFFECTIVE_DATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND PPA.ACTION_TYPE IN ('B'
, 'I'
, 'R'
, 'Q'
, 'V')

Columns