[Home] [Help]
125:
126: -- Archive the payroll action level data and EIT defintions.
127: -- sql string to SELECT a range of assignments eligible for archival.
128: p_sql := ' select distinct p.person_id' ||
129: ' from per_people_f p,' ||
130: ' pay_payroll_actions pa' ||
131: ' where pa.payroll_action_id = :payroll_action_id' ||
132: ' and p.business_group_id = pa.business_group_id' ||
133: ' order by p.person_id';
407: select paa.assignment_action_id,
408: paa.action_sequence,
409: paaf.assignment_id,
410: paa.tax_unit_id
411: from per_people_f pap,
412: per_assignments_f paaf,
413: pay_payroll_actions ppa,
414: pay_payroll_actions ppa1,
415: pay_assignment_actions paa,
459: select paa.assignment_action_id,
460: paa.action_sequence,
461: paaf.assignment_id,
462: paa.tax_unit_id
463: from per_people_f pap,
464: per_assignments_f paaf,
465: pay_payroll_actions ppa,
466: pay_payroll_actions ppa1,
467: pay_assignment_actions paa,
514: select paa.assignment_action_id,
515: paa.action_sequence,
516: paaf.assignment_id,
517: paa.tax_unit_id
518: from per_people_f pap,
519: per_assignments_f paaf,
520: pay_payroll_actions ppa,
521: pay_payroll_actions ppa1,
522: pay_assignment_actions paa,
561: select paa.assignment_action_id,
562: paa.action_sequence,
563: paaf.assignment_id,
564: paa.tax_unit_id
565: from per_people_f pap,
566: per_assignments_f paaf,
567: pay_payroll_actions ppa,
568: pay_payroll_actions ppa1,
569: pay_assignment_actions paa,
611: select paa.assignment_action_id,
612: paa.action_sequence,
613: paaf.assignment_id,
614: paa.tax_unit_id
615: from per_people_f pap,
616: per_assignments_f paaf,
617: pay_payroll_actions ppa,
618: pay_payroll_actions ppa1,
619: pay_assignment_actions paa,
661: select paa.assignment_action_id,
662: paa.action_sequence,
663: paaf.assignment_id,
664: paa.tax_unit_id
665: from per_people_f pap,
666: per_assignments_f paaf,
667: pay_payroll_actions ppa,
668: pay_payroll_actions ppa1,
669: pay_assignment_actions paa,
713: select paa.assignment_action_id,
714: paa.action_sequence,
715: paaf.assignment_id,
716: paa.tax_unit_id
717: from per_people_f pap,
718: per_assignments_f paaf,
719: pay_payroll_actions ppa,
720: pay_payroll_actions ppa1,
721: pay_assignment_actions paa,
758: select paa.assignment_action_id,
759: paa.action_sequence,
760: paaf.assignment_id,
761: paa.tax_unit_id
762: from per_people_f pap,
763: per_assignments_f paaf,
764: pay_payroll_actions ppa,
765: pay_payroll_actions ppa1,
766: pay_assignment_actions paa,
805: select paa.assignment_action_id,
806: paa.action_sequence,
807: paaf.assignment_id,
808: paa.tax_unit_id
809: from per_people_f pap,
810: per_assignments_f paaf,
811: pay_payroll_actions ppa,
812: pay_payroll_actions ppa1,
813: pay_assignment_actions paa,
860: paaf.assignment_id,
861: paa.tax_unit_id
862: from pay_payroll_actions ppa,
863: pay_population_ranges ppr,
864: per_people_f pap,
865: per_assignments_f paaf,
866: per_periods_of_service pps,
867: pay_assignment_actions paa,
868: pay_payroll_actions ppa1
910: select paa.assignment_action_id,
911: paa.action_sequence,
912: paaf.assignment_id,
913: paa.tax_unit_id
914: from per_people_f pap,
915: per_assignments_f paaf,
916: pay_payroll_actions ppa,
917: pay_payroll_actions ppa1,
918: pay_assignment_actions paa,
956: select paa.assignment_action_id,
957: paa.action_sequence,
958: paaf.assignment_id,
959: paa.tax_unit_id
960: from per_people_f pap,
961: per_assignments_f paaf,
962: pay_payroll_actions ppa,
963: pay_payroll_actions ppa1,
964: pay_assignment_actions paa,
1004: select paa.assignment_action_id,
1005: paa.action_sequence,
1006: paaf.assignment_id,
1007: paa.tax_unit_id
1008: from per_people_f pap,
1009: per_assignments_f paaf,
1010: pay_payroll_actions ppa,
1011: pay_payroll_actions ppa1,
1012: pay_assignment_actions paa,
1053: select paa.assignment_action_id,
1054: paa.action_sequence,
1055: paaf.assignment_id,
1056: paa.tax_unit_id
1057: from per_people_f pap,
1058: per_assignments_f paaf,
1059: pay_payroll_actions ppa,
1060: pay_payroll_actions ppa1,
1061: pay_assignment_actions paa,
1104: select paa.assignment_action_id,
1105: paa.action_sequence,
1106: paaf.assignment_id,
1107: paa.tax_unit_id
1108: from per_people_f pap,
1109: per_assignments_f paaf,
1110: pay_payroll_actions ppa,
1111: pay_payroll_actions ppa1,
1112: pay_assignment_actions paa,
1148: select paa.assignment_action_id,
1149: paa.action_sequence,
1150: paaf.assignment_id,
1151: paa.tax_unit_id
1152: from per_people_f pap,
1153: per_assignments_f paaf,
1154: pay_payroll_actions ppa,
1155: pay_payroll_actions ppa1,
1156: pay_assignment_actions paa,
1194: select paa.assignment_action_id,
1195: paa.action_sequence,
1196: paaf.assignment_id,
1197: paa.tax_unit_id
1198: from per_people_f pap,
1199: per_assignments_f paaf,
1200: pay_payroll_actions ppa,
1201: pay_payroll_actions ppa1,
1202: pay_assignment_actions paa,
1241: select paa.assignment_action_id,
1242: paa.action_sequence,
1243: paaf.assignment_id,
1244: paa.tax_unit_id
1245: from per_people_f pap,
1246: per_assignments_f paaf,
1247: pay_payroll_actions ppa,
1248: pay_payroll_actions ppa1,
1249: pay_assignment_actions paa,
1290: select paa.assignment_action_id,
1291: paa.action_sequence,
1292: paaf.assignment_id,
1293: paa.tax_unit_id
1294: from per_people_f pap,
1295: per_assignments_f paaf,
1296: pay_payroll_actions ppa,
1297: pay_payroll_actions ppa1,
1298: pay_assignment_actions paa,
1333: select paa.assignment_action_id,
1334: paa.action_sequence,
1335: paaf.assignment_id,
1336: paa.tax_unit_id
1337: from per_people_f pap,
1338: per_assignments_f paaf,
1339: pay_payroll_actions ppa,
1340: pay_payroll_actions ppa1,
1341: pay_assignment_actions paa,
2762: -- paa.payroll_id, /*Bug 4688872*/
2763: -- papf.payroll_name, /*Bug 4132525, Bug 4688872*/
2764: hsc.segment1 tax_unit_id, /*Bug 4040688*/
2765: hou1.NAME Legal_Employer /*Bug 4132525*/
2766: from per_people_f pap,
2767: per_assignments_f paa,
2768: per_grades_tl pgr, /* Bug 3953702*/
2769: per_periods_of_service pps,
2770: per_pay_bases ppb,