APPS.PAY_KR_NPA_PKG dependencies on PER_PEOPLE_EXTRA_INFO
Line 149: FROM per_people_extra_info pei
145: AND ppa4.report_category = 'A'
146: AND trunc(ppa4.effective_date,'YYYY') = trunc(bppa.effective_date,'YYYY')
147: UNION ALL -- 4660204
148: SELECT NULL 149: FROM per_people_extra_info pei 150: WHERE pei.person_id = ass.person_id
151: AND pei.information_type = 'PER_KR_NATIONAL_PENSION_INFO'
152: AND pei.pei_information7 IN ('03')
153: );