APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on PER_PEOPLE_EXTRA_INFO

Line 1873: FROM per_people_extra_info pei

1869: --
1870: CURSOR csr_passport (p_person_id IN NUMBER)
1871: IS
1872: SELECT pei.pei_information2
1873: FROM per_people_extra_info pei
1874: WHERE pei.person_id = p_person_id
1875: AND pei.pei_information_category = 'PER_PASSPORT_INFO_CN' ;
1876: --
1877: l_passport per_people_extra_info.pei_information2%TYPE;

Line 1877: l_passport per_people_extra_info.pei_information2%TYPE;

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