APPS.PAY_AU_RECONCILIATION_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 645: per_periods_of_service pps

641: pay_payroll_actions ppa,
642: pay_payroll_actions ppa1,
643: pay_assignment_actions paa,
644: hr_organization_units hou,
645: per_periods_of_service pps
646: where ppa.payroll_action_id = c_payroll_action_id
647: and paa.assignment_id = paaf.assignment_id
648: and pap.person_id between c_start_person and c_end_person
649: and pap.person_id = paaf.person_id

Line 697: per_periods_of_service pps,

693: pay_payroll_actions ppa,
694: pay_payroll_actions ppa1,
695: pay_assignment_actions paa,
696: hr_organization_units hou,
697: per_periods_of_service pps,
698: pay_population_ranges ppr
699: where ppa.payroll_action_id = c_payroll_action_id
700: and ppr.payroll_action_id = ppa.payroll_action_id
701: and ppr.chunk_number = c_chunk

Line 752: per_periods_of_service pps

748: pay_payroll_actions ppa,
749: pay_payroll_actions ppa1,
750: pay_assignment_actions paa,
751: hr_organization_units hou,
752: per_periods_of_service pps
753: where ppa.payroll_action_id = c_payroll_action_id
754: and paa.assignment_id = paaf.assignment_id
755: and pap.person_id between c_start_person and c_end_person
756: and pap.person_id = paaf.person_id

Line 800: per_periods_of_service pps,

796: pay_payroll_actions ppa,
797: pay_payroll_actions ppa1,
798: pay_assignment_actions paa,
799: hr_organization_units hou,
800: per_periods_of_service pps,
801: pay_population_ranges ppr
802: where ppa.payroll_action_id = c_payroll_action_id
803: and ppr.payroll_action_id = ppa.payroll_action_id
804: and ppr.chunk_number = c_chunk

Line 856: per_periods_of_service pps

852: pay_payroll_actions ppa,
853: pay_payroll_actions ppa1,
854: pay_assignment_actions paa,
855: pay_assignment_actions paa2, /*Bug# 3935471*/
856: per_periods_of_service pps
857: where ppa.payroll_action_id = c_payroll_action_id
858: and paa.assignment_id = paaf.assignment_id /*Bug# 3935471*/
859: AND paa2.assignment_id = paa.assignment_id
860: and pap.person_id between c_start_person and c_end_person

Line 914: per_periods_of_service pps,

910: pay_payroll_actions ppa,
911: pay_payroll_actions ppa1,
912: pay_assignment_actions paa,
913: pay_assignment_actions paa2,
914: per_periods_of_service pps,
915: pay_population_ranges ppr
916: where ppa.payroll_action_id = c_payroll_action_id
917: and ppr.payroll_action_id = ppa.payroll_action_id
918: and ppr.chunk_number = c_chunk

Line 976: per_periods_of_service pps

972: pay_payroll_actions ppa,
973: pay_payroll_actions ppa1,
974: pay_assignment_actions paa,
975: pay_assignment_actions paa2, /*Bug# 3935471*/
976: per_periods_of_service pps
977: where ppa.payroll_action_id = c_payroll_action_id
978: and paa.assignment_id = paaf.assignment_id
979: AND paa2.assignment_id = paa.assignment_id /*Bug# 3935471*/
980: and pap.person_id between c_start_person and c_end_person

Line 1027: per_periods_of_service pps,

1023: pay_payroll_actions ppa,
1024: pay_payroll_actions ppa1,
1025: pay_assignment_actions paa,
1026: pay_assignment_actions paa2,
1027: per_periods_of_service pps,
1028: pay_population_ranges ppr
1029: where ppa.payroll_action_id = c_payroll_action_id
1030: and ppr.payroll_action_id = ppa.payroll_action_id
1031: and ppr.chunk_number = c_chunk

Line 1078: per_periods_of_service pps

1074: per_assignments_f paaf,
1075: pay_payroll_actions ppa,
1076: pay_payroll_actions ppa1,
1077: pay_assignment_actions paa,
1078: per_periods_of_service pps
1079: where ppa.payroll_action_id = c_payroll_action_id
1080: and paa.assignment_id = paaf.assignment_id
1081: and pap.person_id between c_start_person and c_end_person
1082: and pap.person_id = paaf.person_id

Line 1130: per_periods_of_service pps,

1126: from pay_payroll_actions ppa,
1127: pay_population_ranges ppr,
1128: per_people_f pap,
1129: per_assignments_f paaf,
1130: per_periods_of_service pps,
1131: pay_assignment_actions paa,
1132: pay_payroll_actions ppa1
1133: where ppa.payroll_action_id = c_payroll_action_id
1134: and ppr.payroll_action_id = ppa.payroll_action_id

Line 1185: per_periods_of_service pps

1181: per_assignments_f paaf,
1182: pay_payroll_actions ppa,
1183: pay_payroll_actions ppa1,
1184: pay_assignment_actions paa,
1185: per_periods_of_service pps
1186: where ppa.payroll_action_id = c_payroll_action_id
1187: and paa.assignment_id = paaf.assignment_id
1188: and pap.person_id between c_start_person and c_end_person
1189: and pap.person_id = paaf.person_id

Line 1230: per_periods_of_service pps,

1226: per_assignments_f paaf,
1227: pay_payroll_actions ppa,
1228: pay_payroll_actions ppa1,
1229: pay_assignment_actions paa,
1230: per_periods_of_service pps,
1231: pay_population_ranges ppr
1232: where ppa.payroll_action_id = c_payroll_action_id
1233: and ppr.payroll_action_id = ppa.payroll_action_id
1234: and ppr.chunk_number = c_chunk

Line 1279: per_periods_of_service pps

1275: per_assignments_f paaf,
1276: pay_payroll_actions ppa,
1277: pay_payroll_actions ppa1,
1278: pay_assignment_actions paa,
1279: per_periods_of_service pps
1280: where ppa.payroll_action_id = c_payroll_action_id
1281: and paa.assignment_id = paaf.assignment_id
1282: and pap.person_id between c_start_person and c_end_person
1283: and pap.person_id = paaf.person_id

Line 1328: per_periods_of_service pps,

1324: per_assignments_f paaf,
1325: pay_payroll_actions ppa,
1326: pay_payroll_actions ppa1,
1327: pay_assignment_actions paa,
1328: per_periods_of_service pps,
1329: pay_population_ranges ppr
1330: where ppa.payroll_action_id = c_payroll_action_id
1331: and ppr.payroll_action_id = ppa.payroll_action_id
1332: and ppr.chunk_number = c_chunk

Line 1381: per_periods_of_service pps

1377: per_assignments_f paaf,
1378: pay_payroll_actions ppa,
1379: pay_payroll_actions ppa1,
1380: pay_assignment_actions paa,
1381: per_periods_of_service pps
1382: where ppa.payroll_action_id = c_payroll_action_id
1383: and paa.assignment_id = paaf.assignment_id
1384: and pap.person_id between c_start_person and c_end_person
1385: and pap.person_id = paaf.person_id

Line 1426: per_periods_of_service pps,

1422: per_assignments_f paaf,
1423: pay_payroll_actions ppa,
1424: pay_payroll_actions ppa1,
1425: pay_assignment_actions paa,
1426: per_periods_of_service pps,
1427: pay_population_ranges ppr
1428: where ppa.payroll_action_id = c_payroll_action_id
1429: and ppr.payroll_action_id = ppa.payroll_action_id
1430: and ppr.chunk_number = c_chunk

Line 1474: per_periods_of_service pps

1470: per_assignments_f paaf,
1471: pay_payroll_actions ppa,
1472: pay_payroll_actions ppa1,
1473: pay_assignment_actions paa,
1474: per_periods_of_service pps
1475: where ppa.payroll_action_id = c_payroll_action_id
1476: and paa.assignment_id = paaf.assignment_id
1477: and pap.person_id between c_start_person and c_end_person
1478: and pap.person_id = paaf.person_id

Line 1521: per_periods_of_service pps,

1517: per_assignments_f paaf,
1518: pay_payroll_actions ppa,
1519: pay_payroll_actions ppa1,
1520: pay_assignment_actions paa,
1521: per_periods_of_service pps,
1522: pay_population_ranges ppr
1523: where ppa.payroll_action_id = c_payroll_action_id
1524: and ppr.payroll_action_id = ppa.payroll_action_id
1525: and ppr.chunk_number = c_chunk

Line 1572: per_periods_of_service pps

1568: per_assignments_f paaf,
1569: pay_payroll_actions ppa,
1570: pay_payroll_actions ppa1,
1571: pay_assignment_actions paa,
1572: per_periods_of_service pps
1573: where ppa.payroll_action_id = c_payroll_action_id
1574: and paa.assignment_id = paaf.assignment_id
1575: and pap.person_id between c_start_person and c_end_person
1576: and pap.person_id = paaf.person_id

Line 1616: per_periods_of_service pps,

1612: per_assignments_f paaf,
1613: pay_payroll_actions ppa,
1614: pay_payroll_actions ppa1,
1615: pay_assignment_actions paa,
1616: per_periods_of_service pps,
1617: pay_population_ranges ppr
1618: where ppa.payroll_action_id = c_payroll_action_id
1619: and ppr.payroll_action_id = ppa.payroll_action_id
1620: and ppr.chunk_number = c_chunk