View: PAY_IN_ARCH_LE_EMP_V

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

View Text

SELECT DISTINCT PAI.ACTION_INFORMATION1 EMPLOYEE_NUMBER
, PAI.ACTION_INFORMATION3 GRE_ID
, HOU.NAME GRE_NAME
, PAI.ACTION_INFORMATION2 ASSESSMENT_YEAR
FROM PAY_ACTION_INFORMATION PAI
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
, HR_ORGANIZATION_UNITS HOU
WHERE PAI.ACTION_INFORMATION_CATEGORY = 'IN_EOY_PERSON'
AND PAI.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI.ACTION_CONTEXT_ID = PAA.ASSIGNMENT_ACTION_ID
AND PAA.PAYROLL_ACTION_ID =PPA.PAYROLL_ACTION_ID
AND PPA.BUSINESS_GROUP_ID =FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
AND HOU.ORGANIZATION_ID = PAI.ACTION_INFORMATION3

Columns