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 PAY_PAYROLL_ACTIONS

Line 227: FROM pay_payroll_actions ppa

223: p_year_end,
224: p_business_group_id,
225: p_state_abbrev,
226: p_report_type
227: FROM pay_payroll_actions ppa
228: WHERE payroll_action_id = p_pactid;
229: IF p_state_abbrev <> 'FED' THEN
230: SELECT state_code
231: INTO p_state_code

Line 365: FROM pay_payroll_actions

361: -- archived
362: CURSOR c_gre_payroll_action (cp_gre NUMBER)
363: IS
364: SELECT payroll_action_id
365: FROM pay_payroll_actions
366: WHERE report_type = 'YREND'
367: AND effective_date = p_year_end
368: AND start_date = p_year_start
369: AND business_group_id+0 = p_business_group_id

Line 461: FROM pay_payroll_actions

457: + LENGTH('TRANSFER_TRANS_LEGAL_CO_ID='),
458: (INSTR(legislative_parameters, 'TRANSFER_DATE=')
459: - INSTR(legislative_parameters, 'TRANSFER_TRANS_LEGAL_CO_ID=')
460: - LENGTH('TRANSFER_TRANS_LEGAL_CO_ID=')-1 ))
461: FROM pay_payroll_actions
462: WHERE report_type = 'W2'
463: AND effective_date = p_year_end
464: AND report_qualifier = p_state_abbrev
465: AND business_group_id = p_business_group_id

Line 951: pay_payroll_actions ppa,

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
954: AND ppa.report_type = ''YREND''
955: AND ppa.business_group_id+0 = ppa1.business_group_id

Line 952: pay_payroll_actions ppa1

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
954: AND ppa.report_type = ''YREND''
955: AND ppa.business_group_id+0 = ppa1.business_group_id
956: AND ppa.effective_date = ppa1.effective_date

Line 981: 'pay_payroll_actions ppa, '||

977: 'FROM ff_archive_item_contexts faic, '||
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 '||

Line 983: 'pay_payroll_actions ppa1 '||

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 '||
987: 'AND ppa.report_type = ''YREND'' '||

Line 1049: 'pay_payroll_actions ppa, '||

1045: 'FROM ff_archive_item_contexts faic, '||
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 '||

Line 1051: 'pay_payroll_actions ppa1 '||

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 '||
1055: 'AND ppa.report_type = ''YREND'' '||

Line 1119: pay_payroll_actions ppa,

1115: FROM ff_archive_item_contexts faic,
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

Line 1121: pay_payroll_actions ppa1

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
1125: AND ppa1.effective_date = ppa.effective_date

Line 1207: pay_payroll_actions ppa,

1203: FROM ff_archive_item_contexts faic,
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

Line 1209: pay_payroll_actions ppa1

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
1213: and ppa1.effective_date = ppa.effective_date

Line 1263: SELECT /+ index(ppa pay_payroll_actions_N52) /

1259: ORDER BY 1, 3, 4 DESC, 2
1260: FOR UPDATE OF paf.assignment_id;
1261:
1262: CURSOR c_pr_state_range IS
1263: SELECT /*+ index(ppa pay_payroll_actions_N52) */
1264: to_number(paa.serial_number),
1265: paf.assignment_id,
1266: paa.tax_unit_id,
1267: paf.effective_end_date,

Line 1277: pay_payroll_actions ppa,

1273: FROM ff_archive_item_contexts faic,
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

Line 1279: pay_payroll_actions ppa1,

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
1283: and ppa1.payroll_action_id=ppr.payroll_action_id

Line 1354: pay_payroll_actions ppa,

1350: FROM ff_archive_item_contexts faic,
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

Line 1356: pay_payroll_actions ppa1

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
1360: and ppa1.effective_date = ppa.effective_date

Line 1405: SELECT /+ index(ppa pay_payroll_actions_N52) /

1401: /* Commenting for Performance Issue Bug# 5630156
1402: FOR UPDATE OF paf.assignment_id; */
1403:
1404: CURSOR c_state_range IS
1405: SELECT /*+ index(ppa pay_payroll_actions_N52) */
1406: to_number(paa.serial_number),
1407: paf.assignment_id,
1408: paa.tax_unit_id,
1409: paf.effective_end_date,

Line 1419: pay_payroll_actions ppa,

1415: FROM ff_archive_item_contexts faic,
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

Line 1421: pay_payroll_actions ppa1,

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
1425: and ppa1.payroll_action_id=ppr.payroll_action_id

Line 1492: pay_payroll_actions ppa,

1488: FROM ff_archive_item_contexts faic,
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

Line 1494: pay_payroll_actions ppa1

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
1498: and ppa1.effective_date = ppa.effective_date

Line 1553: SELECT /+ index(ppa pay_payroll_actions_N52) /

1549: ORDER BY 1, 3, 4 DESC, 2 ;
1550:
1551:
1552: CURSOR c_state_indiana_range IS
1553: SELECT /*+ index(ppa pay_payroll_actions_N52) */
1554: to_number(paa.serial_number),
1555: paf.assignment_id,
1556: paa.tax_unit_id,
1557: paf.effective_end_date,

Line 1567: pay_payroll_actions ppa,

1563: FROM ff_archive_item_contexts faic,
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

Line 1569: pay_payroll_actions ppa1,

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
1573: and ppa1.payroll_action_id=ppr.payroll_action_id

Line 1648: pay_payroll_actions ppa,

1644: FROM ff_archive_item_contexts faic,
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

Line 1650: pay_payroll_actions ppa1

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
1654: and ppa1.effective_date = ppa.effective_date

Line 1708: SELECT /+ index(ppa pay_payroll_actions_N52) /

1704: ORDER BY 1, 3, 4 DESC, 2 ;
1705:
1706:
1707: CURSOR c_state_ohio_range IS
1708: SELECT /*+ index(ppa pay_payroll_actions_N52) */
1709: to_number(paa.serial_number),
1710: paf.assignment_id,
1711: paa.tax_unit_id,
1712: paf.effective_end_date,

Line 1722: pay_payroll_actions ppa,

1718: FROM ff_archive_item_contexts faic,
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

Line 1724: pay_payroll_actions ppa1,

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
1728: and ppa1.payroll_action_id=ppr.payroll_action_id

Line 1790: FROM pay_payroll_actions ppa,

1786: paf.assignment_id,
1787: Paa.tax_unit_id, --TO_NUMBER(hsck.segment1),
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

Line 1793: pay_payroll_actions ppa1

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
1797: AND ppa.effective_date = ppa1.effective_date

Line 1817: SELECT /+ index(ppa pay_payroll_actions_N52) / paf.person_id,

1813: ORDER BY 1, 3, 4 DESC, 2
1814: FOR UPDATE OF paf.assignment_id;
1815:
1816: CURSOR c_federal_range IS
1817: SELECT /*+ index(ppa pay_payroll_actions_N52) */ paf.person_id,
1818: paf.assignment_id,
1819: Paa.tax_unit_id, --TO_NUMBER(hsck.segment1),
1820: paf.effective_end_date,
1821: paa.assignment_action_id

Line 1822: FROM pay_payroll_actions ppa,

1818: paf.assignment_id,
1819: Paa.tax_unit_id, --TO_NUMBER(hsck.segment1),
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

Line 1825: pay_payroll_actions ppa1,

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
1829: AND ppr.chunk_number = p_chunk

Line 2502: ,pay_payroll_actions ppa1 /* year End Pre-process for GRE */

2498: CURSOR c_yep_tax_unit_ppa_id(cp_payroll_action_id number )
2499: IS
2500: SELECT DISTINCT paa.tax_unit_id unit_id,ppa1.payroll_action_Id payroll_action,name
2501: FROM pay_assignment_actions paa
2502: ,pay_payroll_actions ppa1 /* year End Pre-process for GRE */
2503: ,pay_payroll_actions ppa /* Year End Pre-process for W-2 */
2504: ,hr_organization_units hou
2505: WHERE
2506: ppa.payroll_action_id = cp_payroll_action_id /* W2 payroll_action_id */

Line 2503: ,pay_payroll_actions ppa /* Year End Pre-process for W-2 */

2499: IS
2500: SELECT DISTINCT paa.tax_unit_id unit_id,ppa1.payroll_action_Id payroll_action,name
2501: FROM pay_assignment_actions paa
2502: ,pay_payroll_actions ppa1 /* year End Pre-process for GRE */
2503: ,pay_payroll_actions ppa /* Year End Pre-process for W-2 */
2504: ,hr_organization_units hou
2505: WHERE
2506: ppa.payroll_action_id = cp_payroll_action_id /* W2 payroll_action_id */
2507: and ppa.payroll_action_id = paa.payroll_action_id

Line 2683: FROM pay_payroll_actions ppa,

2679: SELECT 'RG'
2680: FROM DUAL
2681: WHERE EXISTS
2682: (SELECT NULL
2683: FROM pay_payroll_actions ppa,
2684: ff_archive_items fai
2685: WHERE ppa.report_type = 'YREND'
2686: AND ppa.report_qualifier = 'FED'
2687: AND ppa.report_category = 'RT'

Line 2769: FROM pay_payroll_actions ppa,

2765: SELECT 'RG'
2766: FROM DUAL
2767: WHERE EXISTS
2768: (SELECT NULL
2769: FROM pay_payroll_actions ppa,
2770: ff_archive_items fai
2771: WHERE ppa.report_type = 'YREND'
2772: AND ppa.report_qualifier = 'FED'
2773: AND ppa.report_category = 'RT'

Line 2951: from pay_payroll_actions ppa,

2947:
2948: CURSOR C_EMP_count(cp_tax_unit_id number
2949: ,cp_tax_year varchar2) IS
2950: select count(*)
2951: from pay_payroll_actions ppa,
2952: pay_assignment_actions paa
2953: where ppa.report_type = 'W2'
2954: and ppa.report_qualifier = 'FED'
2955: and ppa.report_category = 'MT'

Line 2967: from pay_payroll_actions ppa

2963:
2964: CURSOR c_rw_error_count ( cp_tax_unit_id number
2965: ,cp_tax_year varchar2) IS
2966: select count(*)
2967: from pay_payroll_actions ppa
2968: ,pay_assignment_actions paa
2969: where ppa.report_type = 'W2'
2970: and ppa.report_qualifier = 'FED'
2971: and ppa.report_category = 'MT'

Line 3034: pay_payroll_actions ppa,

3030: 'A_W2_ROTH_457B_PER_GRE_YTD', nvl(sum(to_number(value)),0) --Bug 13497022
3031: ) val
3032: FROM ff_archive_items fai,
3033: pay_action_interlocks pai,
3034: pay_payroll_actions ppa,
3035: pay_assignment_actions paa,
3036: ff_user_entities fue
3037: where ppa.report_type = 'W2'
3038: and ppa.report_qualifier = 'FED'

Line 3116: ,pay_payroll_actions ppa

3112: ) val
3113: FROM ff_archive_item_contexts faic
3114: ,ff_archive_items fai
3115: ,pay_assignment_actions paa
3116: ,pay_payroll_actions ppa
3117: ,pay_action_interlocks pai
3118: ,ff_user_entities fue
3119: WHERE
3120: ppa.report_type = 'W2'

Line 3149: ,pay_payroll_actions ppa

3145: 'A_W2_GROUP_TERM_LIFE_PER_GRE_YTD', nvl(sum(round(to_number(value),2)),0)) val
3146: FROM ff_archive_item_contexts faic
3147: ,ff_archive_items fai
3148: ,pay_assignment_actions paa
3149: ,pay_payroll_actions ppa
3150: ,pay_action_interlocks pai
3151: ,ff_user_entities fue
3152: WHERE
3153: ppa.report_type = 'W2'

Line 3182: from pay_payroll_actions ppa

3178: group by fue.user_entity_name; */
3179:
3180: CURSOR c_ro_count ( cp_tax_unit_id number) IS
3181: select count(*)
3182: from pay_payroll_actions ppa
3183: ,pay_assignment_actions paa
3184: ,ff_archive_items fai
3185: where ppa.report_type = 'W2'
3186: and ppa.report_qualifier = 'FED'