DBA Data[Home] [Help]

APPS.PAY_GB_COURT_ORDER_UPGRADE dependencies on PER_PEOPLE_F

Line 225: FROM per_people_f ppf

221: is
222: SELECT distinct ppf.full_name ,
223: ppf.person_id,
224: ppf.national_identifier
225: FROM per_people_f ppf
226: ,pay_payrolls_f pf
227: ,per_assignments_f paf
228: WHERE ppf.business_group_id = p_bg_id
229: AND pf.payroll_id = paf.payroll_id

Line 237: FROM per_people_f ppf

233: -- To get the payroll name
234: CURSOR csr_get_payroll(p_person_id in number)
235: IS
236: SELECT distinct pf.payroll_name
237: FROM per_people_f ppf
238: ,pay_payrolls_f pf
239: ,per_assignments_f paf
240: WHERE ppf.business_group_id = p_bg_id
241: AND pf.payroll_id = paf.payroll_id