DBA Data[Home] [Help]

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: );