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 212: FROM pay_payroll_actions ppa

208: p_year_end,
209: p_business_group_id,
210: p_state_abbrev,
211: p_report_type
212: FROM pay_payroll_actions ppa
213: WHERE payroll_action_id = p_pactid;
214: IF p_state_abbrev <> 'FED' THEN
215: SELECT state_code
216: INTO p_state_code

Line 350: FROM pay_payroll_actions

346: -- archived
347: CURSOR c_gre_payroll_action (cp_gre NUMBER)
348: IS
349: SELECT payroll_action_id
350: FROM pay_payroll_actions
351: WHERE report_type = 'YREND'
352: AND effective_date = p_year_end
353: AND start_date = p_year_start
354: AND business_group_id+0 = p_business_group_id

Line 446: FROM pay_payroll_actions

442: + LENGTH('TRANSFER_TRANS_LEGAL_CO_ID='),
443: (INSTR(legislative_parameters, 'TRANSFER_DATE=')
444: - INSTR(legislative_parameters, 'TRANSFER_TRANS_LEGAL_CO_ID=')
445: - LENGTH('TRANSFER_TRANS_LEGAL_CO_ID=')-1 ))
446: FROM pay_payroll_actions
447: WHERE report_type = 'W2'
448: AND effective_date = p_year_end
449: AND report_qualifier = p_state_abbrev
450: AND business_group_id = p_business_group_id

Line 926: pay_payroll_actions ppa,

922: p_sqlstr := '
923: SELECT DISTINCT paf.person_id
924: FROM per_all_assignments_f paf,
925: pay_assignment_actions paa,
926: pay_payroll_actions ppa,
927: pay_payroll_actions ppa1
928: WHERE ppa1.payroll_action_id = :payroll_action_id
929: AND ppa.report_type = ''YREND''
930: AND ppa.business_group_id+0 = ppa1.business_group_id

Line 927: pay_payroll_actions ppa1

923: SELECT DISTINCT paf.person_id
924: FROM per_all_assignments_f paf,
925: pay_assignment_actions paa,
926: pay_payroll_actions ppa,
927: pay_payroll_actions ppa1
928: WHERE ppa1.payroll_action_id = :payroll_action_id
929: AND ppa.report_type = ''YREND''
930: AND ppa.business_group_id+0 = ppa1.business_group_id
931: AND ppa.effective_date = ppa1.effective_date

Line 956: 'pay_payroll_actions ppa, '||

952: 'FROM ff_archive_item_contexts faic, '||
953: 'ff_archive_items fai, '||
954: 'ff_database_items fdi, '||
955: 'pay_assignment_actions paa, '||
956: 'pay_payroll_actions ppa, '||
957: 'per_all_assignments_f paf, '||
958: 'pay_payroll_actions ppa1 '||
959: 'WHERE ppa1.payroll_action_id = :payroll_action_id '||
960: 'AND ppa.business_group_id+0 = ppa1.business_group_id '||

Line 958: 'pay_payroll_actions ppa1 '||

954: 'ff_database_items fdi, '||
955: 'pay_assignment_actions paa, '||
956: 'pay_payroll_actions ppa, '||
957: 'per_all_assignments_f paf, '||
958: 'pay_payroll_actions ppa1 '||
959: 'WHERE ppa1.payroll_action_id = :payroll_action_id '||
960: 'AND ppa.business_group_id+0 = ppa1.business_group_id '||
961: 'AND ppa1.effective_date = ppa.effective_date '||
962: 'AND ppa.report_type = ''YREND'' '||

Line 1024: 'pay_payroll_actions ppa, '||

1020: 'FROM ff_archive_item_contexts faic, '||
1021: 'ff_archive_items fai, '||
1022: 'ff_database_items fdi, '||
1023: 'pay_assignment_actions paa, '||
1024: 'pay_payroll_actions ppa, '||
1025: 'per_all_assignments_f paf, '||
1026: 'pay_payroll_actions ppa1 '||
1027: 'WHERE ppa1.payroll_action_id = :payroll_action_id '||
1028: 'AND ppa.business_group_id+0 = ppa1.business_group_id '||

Line 1026: 'pay_payroll_actions ppa1 '||

1022: 'ff_database_items fdi, '||
1023: 'pay_assignment_actions paa, '||
1024: 'pay_payroll_actions ppa, '||
1025: 'per_all_assignments_f paf, '||
1026: 'pay_payroll_actions ppa1 '||
1027: 'WHERE ppa1.payroll_action_id = :payroll_action_id '||
1028: 'AND ppa.business_group_id+0 = ppa1.business_group_id '||
1029: 'AND ppa1.effective_date = ppa.effective_date '||
1030: 'AND ppa.report_type = ''YREND'' '||

Line 1094: pay_payroll_actions ppa,

1090: FROM ff_archive_item_contexts faic,
1091: ff_archive_items fai,
1092: ff_database_items fdi,
1093: pay_assignment_actions paa,
1094: pay_payroll_actions ppa,
1095: per_all_assignments_f paf,
1096: pay_payroll_actions ppa1
1097: WHERE
1098: ppa1.payroll_action_id = :payroll_action_id

Line 1096: pay_payroll_actions ppa1

1092: ff_database_items fdi,
1093: pay_assignment_actions paa,
1094: pay_payroll_actions ppa,
1095: per_all_assignments_f paf,
1096: pay_payroll_actions ppa1
1097: WHERE
1098: ppa1.payroll_action_id = :payroll_action_id
1099: AND ppa.business_group_id+0 = ppa1.business_group_id
1100: AND ppa1.effective_date = ppa.effective_date

Line 1182: pay_payroll_actions ppa,

1178: FROM ff_archive_item_contexts faic,
1179: ff_archive_items fai,
1180: ff_database_items fdi,
1181: pay_assignment_actions paa,
1182: pay_payroll_actions ppa,
1183: per_all_assignments_f paf,
1184: pay_payroll_actions ppa1
1185: WHERE
1186: ppa1.payroll_action_id = p_pactid

Line 1184: pay_payroll_actions ppa1

1180: ff_database_items fdi,
1181: pay_assignment_actions paa,
1182: pay_payroll_actions ppa,
1183: per_all_assignments_f paf,
1184: pay_payroll_actions ppa1
1185: WHERE
1186: ppa1.payroll_action_id = p_pactid
1187: and ppa.business_group_id+0 = ppa1.business_group_id
1188: and ppa1.effective_date = ppa.effective_date

Line 1254: pay_payroll_actions ppa,

1250: FROM ff_archive_item_contexts faic,
1251: ff_archive_items fai,
1252: ff_database_items fdi,
1253: pay_assignment_actions paa,
1254: pay_payroll_actions ppa,
1255: per_all_assignments_f paf,
1256: pay_payroll_actions ppa1
1257: WHERE
1258: ppa1.payroll_action_id = p_pactid

Line 1256: pay_payroll_actions ppa1

1252: ff_database_items fdi,
1253: pay_assignment_actions paa,
1254: pay_payroll_actions ppa,
1255: per_all_assignments_f paf,
1256: pay_payroll_actions ppa1
1257: WHERE
1258: ppa1.payroll_action_id = p_pactid
1259: and ppa.business_group_id+0 = ppa1.business_group_id
1260: and ppa1.effective_date = ppa.effective_date

Line 1325: pay_payroll_actions ppa,

1321: FROM ff_archive_item_contexts faic,
1322: ff_archive_items fai,
1323: ff_database_items fdi,
1324: pay_assignment_actions paa,
1325: pay_payroll_actions ppa,
1326: per_all_assignments_f paf,
1327: pay_payroll_actions ppa1
1328: WHERE
1329: ppa1.payroll_action_id = p_pactid

Line 1327: pay_payroll_actions ppa1

1323: ff_database_items fdi,
1324: pay_assignment_actions paa,
1325: pay_payroll_actions ppa,
1326: per_all_assignments_f paf,
1327: pay_payroll_actions ppa1
1328: WHERE
1329: ppa1.payroll_action_id = p_pactid
1330: and ppa.business_group_id+0 = ppa1.business_group_id
1331: and ppa1.effective_date = ppa.effective_date

Line 1403: pay_payroll_actions ppa,

1399: FROM ff_archive_item_contexts faic,
1400: ff_archive_items fai,
1401: ff_database_items fdi,
1402: pay_assignment_actions paa,
1403: pay_payroll_actions ppa,
1404: per_all_assignments_f paf,
1405: pay_payroll_actions ppa1
1406: WHERE
1407: ppa1.payroll_action_id = p_pactid

Line 1405: pay_payroll_actions ppa1

1401: ff_database_items fdi,
1402: pay_assignment_actions paa,
1403: pay_payroll_actions ppa,
1404: per_all_assignments_f paf,
1405: pay_payroll_actions ppa1
1406: WHERE
1407: ppa1.payroll_action_id = p_pactid
1408: and ppa.business_group_id+0 = ppa1.business_group_id
1409: and ppa1.effective_date = ppa.effective_date

Line 1468: FROM pay_payroll_actions ppa,

1464: paf.assignment_id,
1465: Paa.tax_unit_id, --TO_NUMBER(hsck.segment1),
1466: paf.effective_end_date,
1467: paa.assignment_action_id
1468: FROM pay_payroll_actions ppa,
1469: pay_assignment_actions paa,
1470: per_all_assignments_f paf,
1471: pay_payroll_actions ppa1
1472: WHERE ppa1.payroll_action_id = p_pactid

Line 1471: pay_payroll_actions ppa1

1467: paa.assignment_action_id
1468: FROM pay_payroll_actions ppa,
1469: pay_assignment_actions paa,
1470: per_all_assignments_f paf,
1471: pay_payroll_actions ppa1
1472: WHERE ppa1.payroll_action_id = p_pactid
1473: AND ppa.report_type = 'YREND'
1474: AND ppa.business_group_id+0 = ppa1.business_group_id
1475: AND ppa.effective_date = ppa1.effective_date

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

2006: CURSOR c_yep_tax_unit_ppa_id(cp_payroll_action_id number )
2007: IS
2008: SELECT DISTINCT paa.tax_unit_id unit_id,ppa1.payroll_action_Id payroll_action,name
2009: FROM pay_assignment_actions paa
2010: ,pay_payroll_actions ppa1 /* year End Pre-process for GRE */
2011: ,pay_payroll_actions ppa /* Year End Pre-process for W-2 */
2012: ,hr_organization_units hou
2013: WHERE
2014: ppa.payroll_action_id = cp_payroll_action_id /* W2 payroll_action_id */

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

2007: IS
2008: SELECT DISTINCT paa.tax_unit_id unit_id,ppa1.payroll_action_Id payroll_action,name
2009: FROM pay_assignment_actions paa
2010: ,pay_payroll_actions ppa1 /* year End Pre-process for GRE */
2011: ,pay_payroll_actions ppa /* Year End Pre-process for W-2 */
2012: ,hr_organization_units hou
2013: WHERE
2014: ppa.payroll_action_id = cp_payroll_action_id /* W2 payroll_action_id */
2015: and ppa.payroll_action_id = paa.payroll_action_id

Line 2191: FROM pay_payroll_actions ppa,

2187: SELECT 'RG'
2188: FROM DUAL
2189: WHERE EXISTS
2190: (SELECT NULL
2191: FROM pay_payroll_actions ppa,
2192: ff_archive_items fai
2193: WHERE ppa.report_type = 'YREND'
2194: AND ppa.report_qualifier = 'FED'
2195: AND ppa.report_category = 'RT'

Line 2277: FROM pay_payroll_actions ppa,

2273: SELECT 'RG'
2274: FROM DUAL
2275: WHERE EXISTS
2276: (SELECT NULL
2277: FROM pay_payroll_actions ppa,
2278: ff_archive_items fai
2279: WHERE ppa.report_type = 'YREND'
2280: AND ppa.report_qualifier = 'FED'
2281: AND ppa.report_category = 'RT'

Line 2457: from pay_payroll_actions ppa,

2453:
2454: CURSOR C_EMP_count(cp_tax_unit_id number
2455: ,cp_tax_year varchar2) IS
2456: select count(*)
2457: from pay_payroll_actions ppa,
2458: pay_assignment_actions paa
2459: where ppa.report_type = 'W2'
2460: and ppa.report_qualifier = 'FED'
2461: and ppa.report_category = 'MT'

Line 2473: from pay_payroll_actions ppa

2469:
2470: CURSOR c_rw_error_count ( cp_tax_unit_id number
2471: ,cp_tax_year varchar2) IS
2472: select count(*)
2473: from pay_payroll_actions ppa
2474: ,pay_assignment_actions paa
2475: where ppa.report_type = 'W2'
2476: and ppa.report_qualifier = 'FED'
2477: and ppa.report_category = 'MT'

Line 2534: pay_payroll_actions ppa,

2530: 'A_W2_ROTH_403B_PER_GRE_YTD', nvl(sum(to_number(value)),0)
2531: ) val
2532: FROM ff_archive_items fai,
2533: pay_action_interlocks pai,
2534: pay_payroll_actions ppa,
2535: pay_assignment_actions paa,
2536: ff_user_entities fue
2537: where ppa.report_type = 'W2'
2538: and ppa.report_qualifier = 'FED'

Line 2610: ,pay_payroll_actions ppa

2606: ) val
2607: FROM ff_archive_item_contexts faic
2608: ,ff_archive_items fai
2609: ,pay_assignment_actions paa
2610: ,pay_payroll_actions ppa
2611: ,pay_action_interlocks pai
2612: ,ff_user_entities fue
2613: WHERE
2614: ppa.report_type = 'W2'

Line 2643: ,pay_payroll_actions ppa

2639: 'A_W2_GROUP_TERM_LIFE_PER_GRE_YTD', nvl(sum(round(to_number(value),2)),0)) val
2640: FROM ff_archive_item_contexts faic
2641: ,ff_archive_items fai
2642: ,pay_assignment_actions paa
2643: ,pay_payroll_actions ppa
2644: ,pay_action_interlocks pai
2645: ,ff_user_entities fue
2646: WHERE
2647: ppa.report_type = 'W2'

Line 2676: from pay_payroll_actions ppa

2672: group by fue.user_entity_name;
2673:
2674: CURSOR c_ro_count ( cp_tax_unit_id number) IS
2675: select count(*)
2676: from pay_payroll_actions ppa
2677: ,pay_assignment_actions paa
2678: ,ff_archive_items fai
2679: where ppa.report_type = 'W2'
2680: and ppa.report_qualifier = 'FED'