DBA Data[Home] [Help]

APPS.PAY_IE_P45PART3_P46_PKG dependencies on PER_ALL_PEOPLE_F

Line 486: per_all_people_f ppf,

482:
483: -- Query to fetch assignment_id.
484: /*l_select_str := 'select distinct paaf.assignment_id, ppf.person_id from
485: per_all_assignments_f paaf,
486: per_all_people_f ppf,
487: pay_all_payrolls_f papf,
488: pay_payroll_actions ppa,
489: hr_soft_coding_keyflex scl
490: where paaf.business_group_id = '|| g_business_group_id

Line 508: per_all_people_f ppf,

504: -- Query to fetch assignment_id.
505: l_select_str := 'select distinct paaf.assignment_id asgid, ppf.person_id perid, pps.period_of_service_id, paaf.assignment_number
506: from
507: per_all_assignments_f paaf,
508: per_all_people_f ppf,
509: pay_all_payrolls_f papf,
510: pay_payroll_actions ppa,
511: hr_soft_coding_keyflex scl,
512: per_periods_of_service pps

Line 832: FROM per_all_people_f ppf,

828: ,flv.meaning COUNTY
829: ,pc.NAME Country_Name
830: ,pa.country
831: -- Bug# 7005067
832: FROM per_all_people_f ppf,
833: per_addresses pa,
834: per_all_assignments_f paa,
835: pay_all_payrolls_f pap,
836: pay_assignment_actions ppaa,