APPS.PAY_KR_HIA_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 138: FROM per_people_extra_info pei

134: AND ppa4.report_category = 'A'
135: AND trunc(ppa4.effective_date, 'YYYY') = trunc(xppa.effective_date, 'YYYY')
136: UNION ALL -- Bug : 4859742
137: (SELECT NULL
138: FROM per_people_extra_info pei
139: WHERE pei.person_id = asg.person_id
140: AND pei.pei_information6 = 'Y'
141: AND pei.information_type = 'PER_KR_HEALTH_INSURANCE_INFO'))
142: AND EXISTS (SELECT NULL

Line 297: FROM per_people_extra_info pei,

293: pei.pei_information1 hi_number,
294: nvl(pei.pei_information4,pei.pei_information2) qualified_date,
295: hhoi.org_information1 business_place_code,
296: NULL business_place_unit
297: FROM per_people_extra_info pei,
298: per_people_f pp,
299: per_assignments_f pa,
300: pay_assignment_actions paa,
301: pay_payroll_actions ppa,