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.

[Home] [Help]

APPS.PAY_US_MMREF_REPORTING dependencies on PAY_ASSIGNMENT_ACTIONS

Line 368: FROM pay_assignment_actions paa

364: CURSOR c_arch_errored_asg (cp_payroll_action_id NUMBER) IS
365: SELECT '1'
366: FROM dual
367: WHERE EXISTS (SELECT '1'
368: FROM pay_assignment_actions paa
369: WHERE paa.payroll_action_id = cp_payroll_action_id
370: AND paa.action_status = 'E'
371: )
372: AND NOT EXISTS ( SELECT '1'

Line 383: FROM pay_assignment_actions paa

379: CURSOR c_arch_retry_pending (cp_payroll_action_id NUMBER) IS
380: SELECT '1'
381: FROM dual
382: WHERE EXISTS (SELECT '1'
383: FROM pay_assignment_actions paa
384: WHERE paa.payroll_action_id = cp_payroll_action_id
385: AND paa.action_status = 'M')
386: AND NOT EXISTS (SELECT '1'
387: FROM pay_action_parameters

Line 925: pay_assignment_actions paa,

921: IF p_report_type = 'FEDW2' THEN
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''

Line 955: 'pay_assignment_actions paa, '||

951: 'to_number(paa.serial_number) '||
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 '||

Line 1023: 'pay_assignment_actions paa, '||

1019: 'to_number(paa.serial_number) '||
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 '||

Line 1093: pay_assignment_actions paa,

1089: to_number(paa.serial_number)
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

Line 1181: pay_assignment_actions paa,

1177: faic.context , 2),0)
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

Line 1253: pay_assignment_actions paa,

1249: faic.context , 2),0)
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

Line 1324: pay_assignment_actions paa,

1320: faic.context , 2),0)
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

Line 1402: pay_assignment_actions paa,

1398: faic.context , 2),0)
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

Line 1469: pay_assignment_actions paa,

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

Line 1788: SELECT pay_assignment_actions_s.nextval

1784:
1785: END IF;
1786: IF (l_report_type = 'FEDW2' and l_value <> 0 ) OR
1787: (l_report_type = 'STW2') then
1788: SELECT pay_assignment_actions_s.nextval
1789: INTO lockingactid
1790: FROM dual;
1791: hr_utility.set_location(
1792: 'pay_us_mmref_reporting.create_assignement_act', 60);

Line 1803: UPDATE pay_assignment_actions

1799: /*IF l_report_type = 'STW2' THEN
1800: hr_utility.set_location(
1801: 'pay_us_mmref_reporting.create_assignement_act', 80);
1802: IF l_w2_box17 > 9999999.99 THEN
1803: UPDATE pay_assignment_actions
1804: SET serial_number = 999999
1805: WHERE assignment_action_id = lockingactid;
1806: END IF;
1807: END IF;*/ -- 4490252

Line 2009: FROM pay_assignment_actions paa

2005:
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

Line 2319: update pay_assignment_actions

2315: BEGIN
2316: IF p_state = 'FED' and p_error = 'Y'
2317: THEN
2318: --raise hr_utility.hr_error;
2319: update pay_assignment_actions
2320: set SERIAL_NUMBER = 'E999999999'
2321: where assignment_action_id = p_assignment_action_id;
2322: return 'Y';
2323: ELSE

Line 2354: FROM pay_assignment_actions

2350: CURSOR c_get_ye_payroll_action (c_tax_unit_id NUMBER
2351: ,c_assignment_action_id NUMBER)
2352: IS
2353: SELECT payroll_action_id
2354: FROM pay_assignment_actions
2355: WHERE tax_unit_id = c_tax_unit_id
2356: AND assignment_action_id = c_assignment_action_id;
2357:
2358: l_tax_unit_name VARCHAR2(2000);

Line 2458: pay_assignment_actions paa

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'
2462: and effective_date = to_date('31/12/'|| cp_tax_year, 'dd/mm/yyyy')

Line 2474: ,pay_assignment_actions paa

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'
2478: and ppa.effective_date = to_date('31/12/'|| cp_tax_year,'dd/mm/yyyy')

Line 2535: pay_assignment_actions paa,

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'
2539: and ppa.report_category = 'MT'

Line 2609: ,pay_assignment_actions paa

2605: 'A_SIT_PRE_TAX_REDNS_PER_JD_GRE_YTD', nvl(sum(round(to_number(value),2)),0)
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

Line 2642: ,pay_assignment_actions paa

2638: 'A_SIT_PRE_TAX_REDNS_PER_JD_GRE_YTD', nvl(sum(round(to_number(value),2)),0),
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

Line 2677: ,pay_assignment_actions paa

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'
2681: and ppa.report_category = 'MT'