DBA Data[Home] [Help]

APPS.PAY_GB_P11D_EDI_2006 dependencies on HR_LOOKUPS

Line 2365: hr_lookups hl

2361: NVL(UPPER(pai_person.action_information8), ' '), -- addr line 4
2362: NVL(UPPER(hl.meaning), ' ') -- addr line 5
2363: from pay_action_information pai_gb,
2364: pay_action_information pai_person,
2365: hr_lookups hl
2366: where pai_person.action_context_id = p_act_id
2367: and pai_person.action_information_category = 'ADDRESS DETAILS'
2368: and pai_person.action_information14 = 'Employee Address'
2369: and pai_person.action_context_type = 'AAP'