APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 1737: FROM per_all_people_f pap

1733: --
1734: CURSOR csr_expatriate (p_person_id IN NUMBER)
1735: IS
1736: SELECT pap.per_information8 expatriate
1737: FROM per_all_people_f pap
1738: WHERE pap.person_id = p_person_id
1739: AND p_date_earned BETWEEN pap.effective_start_date
1740: AND pap.effective_end_date;
1741: --

Line 1751: l_expatriate per_all_people_f.per_information8%TYPE;

1747: AND pei.pei_information_category = 'PER_PASSPORT_INFO_CN' ;
1748: --
1749: l_passport per_people_extra_info.pei_information2%TYPE;
1750: l_person_id per_all_assignments_f.person_id%TYPE;
1751: l_expatriate per_all_people_f.per_information8%TYPE;
1752:
1753: -- Bug 3139966 ends
1754:
1755: l_action_info_id NUMBER;