DBA Data[Home] [Help]

APPS.PAY_GB_P11D_EDI_2008 dependencies on HR_LOOKUPS

Line 2503: hr_lookups hl

2499: NVL(pai_gb.action_information15,' '), -- Date_of_birth EOY 2008
2500: NVL(UPPER(pai_gb.action_information17),' ') -- Gender EOY 2008
2501: from pay_action_information pai_gb,
2502: pay_action_information pai_person,
2503: hr_lookups hl
2504: where pai_person.action_context_id = p_act_id
2505: and pai_person.action_information_category = 'ADDRESS DETAILS'
2506: and pai_person.action_information14 = 'Employee Address'
2507: and pai_person.action_context_type = 'AAP'