APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on PER_PEOPLE_EXTRA_INFO

Line 1745: FROM per_people_extra_info pei

1741: --
1742: CURSOR csr_passport (p_person_id IN NUMBER)
1743: IS
1744: SELECT pei.pei_information2
1745: FROM per_people_extra_info pei
1746: WHERE pei.person_id = p_person_id
1747: AND pei.pei_information_category = 'PER_PASSPORT_INFO_CN' ;
1748: --
1749: l_passport per_people_extra_info.pei_information2%TYPE;

Line 1749: l_passport per_people_extra_info.pei_information2%TYPE;

1745: FROM per_people_extra_info pei
1746: WHERE pei.person_id = p_person_id
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