APPS.PAY_CN_EXT dependencies on PER_PEOPLE_EXTRA_INFO

Line 2293: /*3592894, Removed table per_people_extra_info*/

2289: --
2290:
2291: -- Cursor to fetch Hukou Type
2292: --
2293: /*3592894, Removed table per_people_extra_info*/
2294: CURSOR csr_hukou_type
2295: IS
2296: --
2297: SELECT hr_general.decode_lookup('CN_HUKOU_TYPE',pap.per_information4 )

Line 2316: ,per_people_extra_info ppei

2312: --
2313: SELECT ppei.pei_information2 Work_Life_Start_Date
2314: FROM per_all_assignments_f paa
2315: ,per_all_people_f pap
2316: ,per_people_extra_info ppei
2317: WHERE paa.assignment_id = p_assignment_id
2318: AND pap.person_id = paa.person_id
2319: AND ppei.person_id = pap.person_id (+)
2320: AND ppei.information_type = 'PER_OTH_EMP_DATA_CN'