DBA Data[Home] [Help]

APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on HR_LOOKUPS

Line 2708: hr_lookups hl

2704: NVL(UPPER(pai_person.action_information7), ' '), -- addr line 3
2705: NVL(UPPER(pai_person.action_information8), ' '), -- addr line 4
2706: NVL(UPPER(hl.meaning), ' ') -- addr line 5
2707: from pay_action_information pai_person,
2708: hr_lookups hl
2709: where pai_person.action_context_id = p_assignment_action_id
2710: and pai_person.action_information_category = 'ADDRESS DETAILS'
2711: and pai_person.action_information14 = 'Employee Address'
2712: and pai_person.action_context_type = 'AAP'