APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 1865: FROM per_all_people_f pap

1861: --
1862: CURSOR csr_expatriate (p_person_id IN NUMBER)
1863: IS
1864: SELECT pap.per_information8 expatriate
1865: FROM per_all_people_f pap
1866: WHERE pap.person_id = p_person_id
1867: AND p_date_earned BETWEEN pap.effective_start_date
1868: AND pap.effective_end_date;
1869: --

Line 1879: l_expatriate per_all_people_f.per_information8%TYPE;

1875: AND pei.pei_information_category = 'PER_PASSPORT_INFO_CN' ;
1876: --
1877: l_passport per_people_extra_info.pei_information2%TYPE;
1878: l_person_id per_all_assignments_f.person_id%TYPE;
1879: l_expatriate per_all_people_f.per_information8%TYPE;
1880:
1881: -- Bug 3139966 ends
1882:
1883: l_action_info_id NUMBER;