DBA Data[Home] [Help]

APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on HR_LOOKUPS

Line 2642: hr_lookups hl

2638: NVL(UPPER(pai_person.action_information7), ' '), -- addr line 3
2639: NVL(UPPER(pai_person.action_information8), ' '), -- addr line 4
2640: NVL(UPPER(hl.meaning), ' ') -- addr line 5
2641: from pay_action_information pai_person,
2642: hr_lookups hl
2643: where pai_person.action_context_id = p_assignment_action_id
2644: and pai_person.action_information_category = 'ADDRESS DETAILS'
2645: and pai_person.action_information14 = 'Employee Address'
2646: and pai_person.action_context_type = 'AAP'