[Home] [Help]
413: pay_payroll_actions ppa,
414: pay_payroll_actions ppa1,
415: pay_assignment_actions paa,
416: hr_organization_units hou,
417: per_periods_of_service pps
418: -- ,per_assignment_status_types past
419: where ppa.payroll_action_id = c_payroll_action_id
420: and paa.assignment_id = paaf.assignment_id
421: and pap.person_id between c_start_person and c_end_person
465: pay_payroll_actions ppa,
466: pay_payroll_actions ppa1,
467: pay_assignment_actions paa,
468: hr_organization_units hou,
469: per_periods_of_service pps,
470: pay_population_ranges ppr
471: where ppa.payroll_action_id = c_payroll_action_id
472: and ppr.payroll_action_id = ppa.payroll_action_id
473: and ppr.chunk_number = c_chunk
520: pay_payroll_actions ppa,
521: pay_payroll_actions ppa1,
522: pay_assignment_actions paa,
523: hr_organization_units hou,
524: per_periods_of_service pps
525: where ppa.payroll_action_id = c_payroll_action_id
526: and paa.assignment_id = paaf.assignment_id
527: and pap.person_id between c_start_person and c_end_person
528: and pap.person_id = paaf.person_id
567: pay_payroll_actions ppa,
568: pay_payroll_actions ppa1,
569: pay_assignment_actions paa,
570: hr_organization_units hou,
571: per_periods_of_service pps,
572: pay_population_ranges ppr
573: where ppa.payroll_action_id = c_payroll_action_id
574: and ppr.payroll_action_id = ppa.payroll_action_id
575: and ppr.chunk_number = c_chunk
616: per_assignments_f paaf,
617: pay_payroll_actions ppa,
618: pay_payroll_actions ppa1,
619: pay_assignment_actions paa,
620: per_periods_of_service pps
621: -- ,per_assignment_status_types past
622: where ppa.payroll_action_id = c_payroll_action_id
623: and paa.assignment_id = paaf.assignment_id
624: and pap.person_id between c_start_person and c_end_person
666: per_assignments_f paaf,
667: pay_payroll_actions ppa,
668: pay_payroll_actions ppa1,
669: pay_assignment_actions paa,
670: per_periods_of_service pps,
671: pay_population_ranges ppr
672: where ppa.payroll_action_id = c_payroll_action_id
673: and ppr.payroll_action_id = ppa.payroll_action_id
674: and ppr.chunk_number = c_chunk
718: per_assignments_f paaf,
719: pay_payroll_actions ppa,
720: pay_payroll_actions ppa1,
721: pay_assignment_actions paa,
722: per_periods_of_service pps
723: where ppa.payroll_action_id = c_payroll_action_id
724: and paa.assignment_id = paaf.assignment_id
725: and pap.person_id between c_start_person and c_end_person
726: and pap.person_id = paaf.person_id
763: per_assignments_f paaf,
764: pay_payroll_actions ppa,
765: pay_payroll_actions ppa1,
766: pay_assignment_actions paa,
767: per_periods_of_service pps,
768: pay_population_ranges ppr
769: where ppa.payroll_action_id = c_payroll_action_id
770: and ppr.payroll_action_id = ppa.payroll_action_id
771: and ppr.chunk_number = c_chunk
810: per_assignments_f paaf,
811: pay_payroll_actions ppa,
812: pay_payroll_actions ppa1,
813: pay_assignment_actions paa,
814: per_periods_of_service pps
815: -- per_assignment_status_types past
816: where ppa.payroll_action_id = c_payroll_action_id
817: and paa.assignment_id = paaf.assignment_id
818: and pap.person_id between c_start_person and c_end_person
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
869: where ppa.payroll_action_id = c_payroll_action_id
870: and ppr.payroll_action_id = ppa.payroll_action_id
915: per_assignments_f paaf,
916: pay_payroll_actions ppa,
917: pay_payroll_actions ppa1,
918: pay_assignment_actions paa,
919: per_periods_of_service pps
920: where ppa.payroll_action_id = c_payroll_action_id
921: and paa.assignment_id = paaf.assignment_id
922: and pap.person_id between c_start_person and c_end_person
923: and pap.person_id = paaf.person_id
961: per_assignments_f paaf,
962: pay_payroll_actions ppa,
963: pay_payroll_actions ppa1,
964: pay_assignment_actions paa,
965: per_periods_of_service pps,
966: pay_population_ranges ppr
967: where ppa.payroll_action_id = c_payroll_action_id
968: and ppr.payroll_action_id = ppa.payroll_action_id
969: and ppr.chunk_number = c_chunk
1009: per_assignments_f paaf,
1010: pay_payroll_actions ppa,
1011: pay_payroll_actions ppa1,
1012: pay_assignment_actions paa,
1013: per_periods_of_service pps
1014: -- ,per_assignment_status_types past
1015: where ppa.payroll_action_id = c_payroll_action_id
1016: and paa.assignment_id = paaf.assignment_id
1017: and pap.person_id between c_start_person and c_end_person
1058: per_assignments_f paaf,
1059: pay_payroll_actions ppa,
1060: pay_payroll_actions ppa1,
1061: pay_assignment_actions paa,
1062: per_periods_of_service pps,
1063: pay_population_ranges ppr
1064: where ppa.payroll_action_id = c_payroll_action_id
1065: and ppr.payroll_action_id = ppa.payroll_action_id
1066: and ppr.chunk_number = c_chunk
1109: per_assignments_f paaf,
1110: pay_payroll_actions ppa,
1111: pay_payroll_actions ppa1,
1112: pay_assignment_actions paa,
1113: per_periods_of_service pps
1114: where ppa.payroll_action_id = c_payroll_action_id
1115: and paa.assignment_id = paaf.assignment_id
1116: and pap.person_id between c_start_person and c_end_person
1117: and pap.person_id = paaf.person_id
1153: per_assignments_f paaf,
1154: pay_payroll_actions ppa,
1155: pay_payroll_actions ppa1,
1156: pay_assignment_actions paa,
1157: per_periods_of_service pps,
1158: pay_population_ranges ppr
1159: where ppa.payroll_action_id = c_payroll_action_id
1160: and ppr.payroll_action_id = ppa.payroll_action_id
1161: and ppr.chunk_number = c_chunk
1199: per_assignments_f paaf,
1200: pay_payroll_actions ppa,
1201: pay_payroll_actions ppa1,
1202: pay_assignment_actions paa,
1203: per_periods_of_service pps
1204: -- ,per_assignment_status_types past
1205: where ppa.payroll_action_id = c_payroll_action_id
1206: and paa.assignment_id = paaf.assignment_id
1207: and pap.person_id between c_start_person and c_end_person
1246: per_assignments_f paaf,
1247: pay_payroll_actions ppa,
1248: pay_payroll_actions ppa1,
1249: pay_assignment_actions paa,
1250: per_periods_of_service pps,
1251: pay_population_ranges ppr
1252: where ppa.payroll_action_id = c_payroll_action_id
1253: and ppr.payroll_action_id = ppa.payroll_action_id
1254: and ppr.chunk_number = c_chunk
1295: per_assignments_f paaf,
1296: pay_payroll_actions ppa,
1297: pay_payroll_actions ppa1,
1298: pay_assignment_actions paa,
1299: per_periods_of_service pps
1300: where ppa.payroll_action_id = c_payroll_action_id
1301: and paa.assignment_id = paaf.assignment_id
1302: and pap.person_id between c_start_person and c_end_person
1303: and pap.person_id = paaf.person_id
1338: per_assignments_f paaf,
1339: pay_payroll_actions ppa,
1340: pay_payroll_actions ppa1,
1341: pay_assignment_actions paa,
1342: per_periods_of_service pps,
1343: pay_population_ranges ppr
1344: where ppa.payroll_action_id = c_payroll_action_id
1345: and ppr.payroll_action_id = ppa.payroll_action_id
1346: and ppr.chunk_number = c_chunk
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,
2771: per_pay_proposals pro,
2772: per_assignment_status_types past,
2773: hr_soft_coding_keyflex hsc, /*Bug 4040688*/