VIEW: APPS.PAY_IN_ARCH_LE_EMP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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