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'