APPS.PAY_AU_RECONCILIATION_PKG dependencies on PER_PEOPLE_F

Line 343: ' from per_people_f p,' ||

339:
340: -- Archive the payroll action level data and EIT defintions.
341: -- sql string to SELECT a range of assignments eligible for archival.
342: p_sql := ' select distinct p.person_id' ||
343: ' from per_people_f p,' ||
344: ' pay_payroll_actions pa' ||
345: ' where pa.payroll_action_id = :payroll_action_id' ||
346: ' and p.business_group_id = pa.business_group_id' ||
347: ' order by p.person_id';

Line 525: from per_people_f pap,

521: select paa.assignment_action_id,
522: paa.action_sequence,
523: paaf.assignment_id,
524: paa.tax_unit_id
525: from per_people_f pap,
526: per_assignments_f paaf,
527: pay_payroll_actions ppa,
528: pay_payroll_actions ppa1,
529: pay_assignment_actions paa,

Line 578: from per_people_f pap,

574: select paa.assignment_action_id,
575: paa.action_sequence,
576: paaf.assignment_id,
577: paa.tax_unit_id
578: from per_people_f pap,
579: per_assignments_f paaf,
580: pay_payroll_actions ppa,
581: pay_payroll_actions ppa1,
582: pay_assignment_actions paa,

Line 631: from per_people_f pap,

627: paaf.assignment_id,
628: paa.tax_unit_id,
629: paa.source_action_id master_action_id, /*Bug# 3935471*/
630: paa2.tax_unit_id master_tax_unit_id /*Bug# 3935471*/
631: from per_people_f pap,
632: per_assignments_f paaf,
633: pay_payroll_actions ppa,
634: pay_payroll_actions ppa1,
635: pay_assignment_actions paa,

Line 690: from per_people_f pap,

686: paaf.assignment_id,
687: paa.tax_unit_id,
688: paa.source_action_id master_action_id, /*Bug# 3935471*/
689: paa2.tax_unit_id master_tax_unit_id /*Bug# 3935471*/
690: from per_people_f pap,
691: per_assignments_f paaf,
692: pay_payroll_actions ppa,
693: pay_payroll_actions ppa1,
694: pay_assignment_actions paa,

Line 739: from per_people_f pap,

735: select paa.assignment_action_id,
736: paa.action_sequence,
737: paaf.assignment_id,
738: paa.tax_unit_id
739: from per_people_f pap,
740: per_assignments_f paaf,
741: pay_payroll_actions ppa,
742: pay_payroll_actions ppa1,
743: pay_assignment_actions paa,

Line 789: from per_people_f pap,

785: select paa.assignment_action_id,
786: paa.action_sequence,
787: paaf.assignment_id,
788: paa.tax_unit_id
789: from per_people_f pap,
790: per_assignments_f paaf,
791: pay_payroll_actions ppa,
792: pay_payroll_actions ppa1,
793: pay_assignment_actions paa,

Line 835: from per_people_f pap,

831: select paa.assignment_action_id,
832: paa.action_sequence,
833: paaf.assignment_id,
834: paa.tax_unit_id
835: from per_people_f pap,
836: per_assignments_f paaf,
837: pay_payroll_actions ppa,
838: pay_payroll_actions ppa1,
839: pay_assignment_actions paa,

Line 884: from per_people_f pap,

880: select paa.assignment_action_id,
881: paa.action_sequence,
882: paaf.assignment_id,
883: paa.tax_unit_id
884: from per_people_f pap,
885: per_assignments_f paaf,
886: pay_payroll_actions ppa,
887: pay_payroll_actions ppa1,
888: pay_assignment_actions paa,

Line 928: from per_people_f pap,

924: select paa.assignment_action_id,
925: paa.action_sequence,
926: paaf.assignment_id,
927: paa.tax_unit_id
928: from per_people_f pap,
929: per_assignments_f paaf,
930: pay_payroll_actions ppa,
931: pay_payroll_actions ppa1,
932: pay_assignment_actions paa,

Line 975: from per_people_f pap,

971: select paa.assignment_action_id,
972: paa.action_sequence,
973: paaf.assignment_id,
974: paa.tax_unit_id
975: from per_people_f pap,
976: per_assignments_f paaf,
977: pay_payroll_actions ppa,
978: pay_payroll_actions ppa1,
979: pay_assignment_actions paa,

Line 1760: from per_people_f pap,

1756: -- paa.payroll_id, /*Bug 4688800*/
1757: -- papf.payroll_name, /*Bug 4132525, Bug 4688800*/
1758: hsc.segment1 tax_unit_id, /*Bug 4040688*/
1759: hou1.NAME Legal_Employer /*Bug 4132525*/
1760: from per_people_f pap,
1761: per_assignments_f paa,
1762: hr_soft_coding_keyflex hsc, /*Bug 4040688*/
1763: hr_organization_units hou, /*Bug 4132525*/
1764: hr_organization_units hou1 /*Bug 4132525*/