eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_RECONCILIATION_PKG dependencies on PER_PEOPLE_F

Line 457: ' from per_people_f p,' ||

453:
454: -- Archive the payroll action level data and EIT defintions.
455: -- sql string to SELECT a range of assignments eligible for archival.
456: p_sql := ' select distinct p.person_id' ||
457: ' from per_people_f p,' ||
458: ' pay_payroll_actions pa' ||
459: ' where pa.payroll_action_id = :payroll_action_id' ||
460: ' and p.business_group_id = pa.business_group_id' ||
461: ' order by p.person_id';

Line 639: from per_people_f pap,

635: select paa.assignment_action_id,
636: paa.action_sequence,
637: paaf.assignment_id,
638: paa.tax_unit_id
639: from per_people_f pap,
640: per_assignments_f paaf,
641: pay_payroll_actions ppa,
642: pay_payroll_actions ppa1,
643: pay_assignment_actions paa,

Line 691: from per_people_f pap,

687: select paa.assignment_action_id,
688: paa.action_sequence,
689: paaf.assignment_id,
690: paa.tax_unit_id
691: from per_people_f pap,
692: per_assignments_f paaf,
693: pay_payroll_actions ppa,
694: pay_payroll_actions ppa1,
695: pay_assignment_actions paa,

Line 746: from per_people_f pap,

742: select paa.assignment_action_id,
743: paa.action_sequence,
744: paaf.assignment_id,
745: paa.tax_unit_id
746: from per_people_f pap,
747: per_assignments_f paaf,
748: pay_payroll_actions ppa,
749: pay_payroll_actions ppa1,
750: pay_assignment_actions paa,

Line 794: from per_people_f pap,

790: select paa.assignment_action_id,
791: paa.action_sequence,
792: paaf.assignment_id,
793: paa.tax_unit_id
794: from per_people_f pap,
795: per_assignments_f paaf,
796: pay_payroll_actions ppa,
797: pay_payroll_actions ppa1,
798: pay_assignment_actions paa,

Line 850: from per_people_f pap,

846: paaf.assignment_id,
847: paa.tax_unit_id,
848: paa.source_action_id master_action_id, /*Bug# 3935471*/
849: paa2.tax_unit_id master_tax_unit_id /*Bug# 3935471*/
850: from per_people_f pap,
851: per_assignments_f paaf,
852: pay_payroll_actions ppa,
853: pay_payroll_actions ppa1,
854: pay_assignment_actions paa,

Line 908: from per_people_f pap,

904: paaf.assignment_id,
905: paa.tax_unit_id,
906: paa.source_action_id master_action_id,
907: paa2.tax_unit_id master_tax_unit_id
908: from per_people_f pap,
909: per_assignments_f paaf,
910: pay_payroll_actions ppa,
911: pay_payroll_actions ppa1,
912: pay_assignment_actions paa,

Line 970: from per_people_f pap,

966: paaf.assignment_id,
967: paa.tax_unit_id,
968: paa.source_action_id master_action_id, /*Bug# 3935471*/
969: paa2.tax_unit_id master_tax_unit_id /*Bug# 3935471*/
970: from per_people_f pap,
971: per_assignments_f paaf,
972: pay_payroll_actions ppa,
973: pay_payroll_actions ppa1,
974: pay_assignment_actions paa,

Line 1021: from per_people_f pap,

1017: paaf.assignment_id,
1018: paa.tax_unit_id,
1019: paa.source_action_id master_action_id,
1020: paa2.tax_unit_id master_tax_unit_id
1021: from per_people_f pap,
1022: per_assignments_f paaf,
1023: pay_payroll_actions ppa,
1024: pay_payroll_actions ppa1,
1025: pay_assignment_actions paa,

Line 1073: from per_people_f pap,

1069: select paa.assignment_action_id,
1070: paa.action_sequence,
1071: paaf.assignment_id,
1072: paa.tax_unit_id
1073: from per_people_f pap,
1074: per_assignments_f paaf,
1075: pay_payroll_actions ppa,
1076: pay_payroll_actions ppa1,
1077: pay_assignment_actions paa,

Line 1128: per_people_f pap,

1124: paaf.assignment_id,
1125: paa.tax_unit_id
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

Line 1180: from per_people_f pap,

1176: select paa.assignment_action_id,
1177: paa.action_sequence,
1178: paaf.assignment_id,
1179: paa.tax_unit_id
1180: from per_people_f pap,
1181: per_assignments_f paaf,
1182: pay_payroll_actions ppa,
1183: pay_payroll_actions ppa1,
1184: pay_assignment_actions paa,

Line 1225: from per_people_f pap,

1221: select paa.assignment_action_id,
1222: paa.action_sequence,
1223: paaf.assignment_id,
1224: paa.tax_unit_id
1225: from per_people_f pap,
1226: per_assignments_f paaf,
1227: pay_payroll_actions ppa,
1228: pay_payroll_actions ppa1,
1229: pay_assignment_actions paa,

Line 1274: from per_people_f pap,

1270: select paa.assignment_action_id,
1271: paa.action_sequence,
1272: paaf.assignment_id,
1273: paa.tax_unit_id
1274: from per_people_f pap,
1275: per_assignments_f paaf,
1276: pay_payroll_actions ppa,
1277: pay_payroll_actions ppa1,
1278: pay_assignment_actions paa,

Line 1323: from per_people_f pap,

1319: select paa.assignment_action_id,
1320: paa.action_sequence,
1321: paaf.assignment_id,
1322: paa.tax_unit_id
1323: from per_people_f pap,
1324: per_assignments_f paaf,
1325: pay_payroll_actions ppa,
1326: pay_payroll_actions ppa1,
1327: pay_assignment_actions paa,

Line 1376: from per_people_f pap,

1372: select paa.assignment_action_id,
1373: paa.action_sequence,
1374: paaf.assignment_id,
1375: paa.tax_unit_id
1376: from per_people_f pap,
1377: per_assignments_f paaf,
1378: pay_payroll_actions ppa,
1379: pay_payroll_actions ppa1,
1380: pay_assignment_actions paa,

Line 1421: from per_people_f pap,

1417: select paa.assignment_action_id,
1418: paa.action_sequence,
1419: paaf.assignment_id,
1420: paa.tax_unit_id
1421: from per_people_f pap,
1422: per_assignments_f paaf,
1423: pay_payroll_actions ppa,
1424: pay_payroll_actions ppa1,
1425: pay_assignment_actions paa,

Line 1469: from per_people_f pap,

1465: select paa.assignment_action_id,
1466: paa.action_sequence,
1467: paaf.assignment_id,
1468: paa.tax_unit_id
1469: from per_people_f pap,
1470: per_assignments_f paaf,
1471: pay_payroll_actions ppa,
1472: pay_payroll_actions ppa1,
1473: pay_assignment_actions paa,

Line 1516: from per_people_f pap,

1512: select paa.assignment_action_id,
1513: paa.action_sequence,
1514: paaf.assignment_id,
1515: paa.tax_unit_id
1516: from per_people_f pap,
1517: per_assignments_f paaf,
1518: pay_payroll_actions ppa,
1519: pay_payroll_actions ppa1,
1520: pay_assignment_actions paa,

Line 1567: from per_people_f pap,

1563: select paa.assignment_action_id,
1564: paa.action_sequence,
1565: paaf.assignment_id,
1566: paa.tax_unit_id
1567: from per_people_f pap,
1568: per_assignments_f paaf,
1569: pay_payroll_actions ppa,
1570: pay_payroll_actions ppa1,
1571: pay_assignment_actions paa,

Line 1611: from per_people_f pap,

1607: select paa.assignment_action_id,
1608: paa.action_sequence,
1609: paaf.assignment_id,
1610: paa.tax_unit_id
1611: from per_people_f pap,
1612: per_assignments_f paaf,
1613: pay_payroll_actions ppa,
1614: pay_payroll_actions ppa1,
1615: pay_assignment_actions paa,

Line 3034: from per_people_f pap,

3030: -- paa.payroll_id, /*Bug 4688800*/
3031: -- papf.payroll_name, /*Bug 4132525, Bug 4688800*/
3032: hsc.segment1 tax_unit_id, /*Bug 4040688*/
3033: hou1.NAME Legal_Employer /*Bug 4132525*/
3034: from per_people_f pap,
3035: per_assignments_f paa,
3036: hr_soft_coding_keyflex hsc, /*Bug 4040688*/
3037: hr_all_organization_units hou, /*Bug 4132525*/
3038: hr_all_organization_units hou1 /*Bug 4132525*/