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_US_MMREF_REPORTING dependencies on PER_ALL_ASSIGNMENTS_F

Line 949: FROM per_all_assignments_f paf,

945: close csr_action_parameter;
946: IF g_action_param_val = 'Y' or p_report_type = 'FEDW2' THEN
947: p_sqlstr := '
948: SELECT DISTINCT paf.person_id
949: FROM per_all_assignments_f paf,
950: pay_assignment_actions paa,
951: pay_payroll_actions ppa,
952: pay_payroll_actions ppa1
953: WHERE ppa1.payroll_action_id = :payroll_action_id

Line 982: 'per_all_assignments_f paf, '||

978: 'ff_archive_items fai, '||
979: 'ff_database_items fdi, '||
980: 'pay_assignment_actions paa, '||
981: 'pay_payroll_actions ppa, '||
982: 'per_all_assignments_f paf, '||
983: 'pay_payroll_actions ppa1 '||
984: 'WHERE ppa1.payroll_action_id = :payroll_action_id '||
985: 'AND ppa.business_group_id+0 = ppa1.business_group_id '||
986: 'AND ppa1.effective_date = ppa.effective_date '||

Line 1050: 'per_all_assignments_f paf, '||

1046: 'ff_archive_items fai, '||
1047: 'ff_database_items fdi, '||
1048: 'pay_assignment_actions paa, '||
1049: 'pay_payroll_actions ppa, '||
1050: 'per_all_assignments_f paf, '||
1051: 'pay_payroll_actions ppa1 '||
1052: 'WHERE ppa1.payroll_action_id = :payroll_action_id '||
1053: 'AND ppa.business_group_id+0 = ppa1.business_group_id '||
1054: 'AND ppa1.effective_date = ppa.effective_date '||

Line 1120: per_all_assignments_f paf,

1116: ff_archive_items fai,
1117: ff_database_items fdi,
1118: pay_assignment_actions paa,
1119: pay_payroll_actions ppa,
1120: per_all_assignments_f paf,
1121: pay_payroll_actions ppa1
1122: WHERE
1123: ppa1.payroll_action_id = :payroll_action_id
1124: AND ppa.business_group_id+0 = ppa1.business_group_id

Line 1208: per_all_assignments_f paf,

1204: ff_archive_items fai,
1205: ff_database_items fdi,
1206: pay_assignment_actions paa,
1207: pay_payroll_actions ppa,
1208: per_all_assignments_f paf,
1209: pay_payroll_actions ppa1
1210: WHERE
1211: ppa1.payroll_action_id = p_pactid
1212: and ppa.business_group_id+0 = ppa1.business_group_id

Line 1278: per_all_assignments_f paf,

1274: ff_archive_items fai,
1275: ff_database_items fdi,
1276: pay_assignment_actions paa,
1277: pay_payroll_actions ppa,
1278: per_all_assignments_f paf,
1279: pay_payroll_actions ppa1,
1280: pay_population_ranges ppr
1281: WHERE
1282: ppa1.payroll_action_id = p_pactid

Line 1355: per_all_assignments_f paf,

1351: ff_archive_items fai,
1352: ff_database_items fdi,
1353: pay_assignment_actions paa,
1354: pay_payroll_actions ppa,
1355: per_all_assignments_f paf,
1356: pay_payroll_actions ppa1
1357: WHERE
1358: ppa1.payroll_action_id = p_pactid
1359: and ppa.business_group_id+0 = ppa1.business_group_id

Line 1420: per_all_assignments_f paf,

1416: ff_archive_items fai,
1417: ff_database_items fdi,
1418: pay_assignment_actions paa,
1419: pay_payroll_actions ppa,
1420: per_all_assignments_f paf,
1421: pay_payroll_actions ppa1,
1422: pay_population_ranges ppr
1423: WHERE
1424: ppa1.payroll_action_id = p_pactid

Line 1493: per_all_assignments_f paf,

1489: ff_archive_items fai,
1490: ff_database_items fdi,
1491: pay_assignment_actions paa,
1492: pay_payroll_actions ppa,
1493: per_all_assignments_f paf,
1494: pay_payroll_actions ppa1
1495: WHERE
1496: ppa1.payroll_action_id = p_pactid
1497: and ppa.business_group_id+0 = ppa1.business_group_id

Line 1568: per_all_assignments_f paf,

1564: ff_archive_items fai,
1565: ff_database_items fdi,
1566: pay_assignment_actions paa,
1567: pay_payroll_actions ppa,
1568: per_all_assignments_f paf,
1569: pay_payroll_actions ppa1,
1570: pay_population_ranges ppr
1571: WHERE
1572: ppa1.payroll_action_id = p_pactid

Line 1649: per_all_assignments_f paf,

1645: ff_archive_items fai,
1646: ff_database_items fdi,
1647: pay_assignment_actions paa,
1648: pay_payroll_actions ppa,
1649: per_all_assignments_f paf,
1650: pay_payroll_actions ppa1
1651: WHERE
1652: ppa1.payroll_action_id = p_pactid
1653: and ppa.business_group_id+0 = ppa1.business_group_id

Line 1723: per_all_assignments_f paf,

1719: ff_archive_items fai,
1720: ff_database_items fdi,
1721: pay_assignment_actions paa,
1722: pay_payroll_actions ppa,
1723: per_all_assignments_f paf,
1724: pay_payroll_actions ppa1,
1725: pay_population_ranges ppr
1726: WHERE
1727: ppa1.payroll_action_id = p_pactid

Line 1792: per_all_assignments_f paf,

1788: paf.effective_end_date,
1789: paa.assignment_action_id
1790: FROM pay_payroll_actions ppa,
1791: pay_assignment_actions paa,
1792: per_all_assignments_f paf,
1793: pay_payroll_actions ppa1
1794: WHERE ppa1.payroll_action_id = p_pactid
1795: AND ppa.report_type = 'YREND'
1796: AND ppa.business_group_id+0 = ppa1.business_group_id

Line 1824: per_all_assignments_f paf,

1820: paf.effective_end_date,
1821: paa.assignment_action_id
1822: FROM pay_payroll_actions ppa,
1823: pay_assignment_actions paa,
1824: per_all_assignments_f paf,
1825: pay_payroll_actions ppa1,
1826: pay_population_ranges ppr
1827: WHERE ppa1.payroll_action_id = p_pactid
1828: and ppa1.payroll_action_id=ppr.payroll_action_id