APPS.PAY_AU_REC_DET_ARCHIVE dependencies on PER_PEOPLE_F

Line 122: ' from per_people_f p,' ||

118:
119: -- Archive the payroll action level data and EIT defintions.
120: -- sql string to SELECT a range of assignments eligible for archival.
121: p_sql := ' select distinct p.person_id' ||
122: ' from per_people_f p,' ||
123: ' pay_payroll_actions pa' ||
124: ' where pa.payroll_action_id = :payroll_action_id' ||
125: ' and p.business_group_id = pa.business_group_id' ||
126: ' order by p.person_id';

Line 339: from per_people_f pap,

335: select paa.assignment_action_id,
336: paa.action_sequence,
337: paaf.assignment_id,
338: paa.tax_unit_id
339: from per_people_f pap,
340: per_assignments_f paaf,
341: pay_payroll_actions ppa,
342: pay_payroll_actions ppa1,
343: pay_assignment_actions paa,

Line 392: from per_people_f pap,

388: select paa.assignment_action_id,
389: paa.action_sequence,
390: paaf.assignment_id,
391: paa.tax_unit_id
392: from per_people_f pap,
393: per_assignments_f paaf,
394: pay_payroll_actions ppa,
395: pay_payroll_actions ppa1,
396: pay_assignment_actions paa,

Line 439: from per_people_f pap,

435: select paa.assignment_action_id,
436: paa.action_sequence,
437: paaf.assignment_id,
438: paa.tax_unit_id
439: from per_people_f pap,
440: per_assignments_f paaf,
441: pay_payroll_actions ppa,
442: pay_payroll_actions ppa1,
443: pay_assignment_actions paa,

Line 490: from per_people_f pap,

486: select paa.assignment_action_id,
487: paa.action_sequence,
488: paaf.assignment_id,
489: paa.tax_unit_id
490: from per_people_f pap,
491: per_assignments_f paaf,
492: pay_payroll_actions ppa,
493: pay_payroll_actions ppa1,
494: pay_assignment_actions paa,

Line 534: from per_people_f pap,

530: select paa.assignment_action_id,
531: paa.action_sequence,
532: paaf.assignment_id,
533: paa.tax_unit_id
534: from per_people_f pap,
535: per_assignments_f paaf,
536: pay_payroll_actions ppa,
537: pay_payroll_actions ppa1,
538: pay_assignment_actions paa,

Line 584: from per_people_f pap,

580: select paa.assignment_action_id,
581: paa.action_sequence,
582: paaf.assignment_id,
583: paa.tax_unit_id
584: from per_people_f pap,
585: per_assignments_f paaf,
586: pay_payroll_actions ppa,
587: pay_payroll_actions ppa1,
588: pay_assignment_actions paa,

Line 629: from per_people_f pap,

625: select paa.assignment_action_id,
626: paa.action_sequence,
627: paaf.assignment_id,
628: paa.tax_unit_id
629: from per_people_f pap,
630: per_assignments_f paaf,
631: pay_payroll_actions ppa,
632: pay_payroll_actions ppa1,
633: pay_assignment_actions paa,

Line 678: from per_people_f pap,

674: select paa.assignment_action_id,
675: paa.action_sequence,
676: paaf.assignment_id,
677: paa.tax_unit_id
678: from per_people_f pap,
679: per_assignments_f paaf,
680: pay_payroll_actions ppa,
681: pay_payroll_actions ppa1,
682: pay_assignment_actions paa,

Line 721: from per_people_f pap,

717: select paa.assignment_action_id,
718: paa.action_sequence,
719: paaf.assignment_id,
720: paa.tax_unit_id
721: from per_people_f pap,
722: per_assignments_f paaf,
723: pay_payroll_actions ppa,
724: pay_payroll_actions ppa1,
725: pay_assignment_actions paa,

Line 768: from per_people_f pap,

764: select paa.assignment_action_id,
765: paa.action_sequence,
766: paaf.assignment_id,
767: paa.tax_unit_id
768: from per_people_f pap,
769: per_assignments_f paaf,
770: pay_payroll_actions ppa,
771: pay_payroll_actions ppa1,
772: pay_assignment_actions paa,

Line 1567: from per_people_f pap,

1563: -- paa.payroll_id, /*Bug 4688872*/
1564: -- papf.payroll_name, /*Bug 4132525, Bug 4688872*/
1565: hsc.segment1 tax_unit_id, /*Bug 4040688*/
1566: hou1.NAME Legal_Employer /*Bug 4132525*/
1567: from per_people_f pap,
1568: per_assignments_f paa,
1569: per_grades_tl pgr, /* Bug 3953702*/
1570: per_periods_of_service pps,
1571: per_pay_bases ppb,