DBA Data[Home] [Help]

APPS.PAY_IE_P45PART3_P46_PKG dependencies on PER_ALL_PEOPLE_F

Line 489: per_all_people_f ppf,

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

Line 511: per_all_people_f ppf,

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

Line 835: FROM per_all_people_f ppf,

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