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_ASSIGNMENT_ACTIONS

Line 383: FROM pay_assignment_actions paa

379: CURSOR c_arch_errored_asg (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 = 'E'
386: )
387: AND NOT EXISTS ( SELECT '1'

Line 398: FROM pay_assignment_actions paa

394: CURSOR c_arch_retry_pending (cp_payroll_action_id NUMBER) IS
395: SELECT '1'
396: FROM dual
397: WHERE EXISTS (SELECT '1'
398: FROM pay_assignment_actions paa
399: WHERE paa.payroll_action_id = cp_payroll_action_id
400: AND paa.action_status = 'M')
401: AND NOT EXISTS (SELECT '1'
402: FROM pay_action_parameters

Line 950: pay_assignment_actions paa,

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

Line 980: 'pay_assignment_actions paa, '||

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

Line 1048: 'pay_assignment_actions paa, '||

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

Line 1118: pay_assignment_actions paa,

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

Line 1206: pay_assignment_actions paa,

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

Line 1276: pay_assignment_actions paa,

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

Line 1353: pay_assignment_actions paa,

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

Line 1418: pay_assignment_actions paa,

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

Line 1491: pay_assignment_actions paa,

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

Line 1566: pay_assignment_actions paa,

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

Line 1647: pay_assignment_actions paa,

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

Line 1721: pay_assignment_actions paa,

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

Line 1791: pay_assignment_actions paa,

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

Line 1823: pay_assignment_actions paa,

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
1827: WHERE ppa1.payroll_action_id = p_pactid

Line 2260: SELECT pay_assignment_actions_s.nextval

2256:
2257: END IF;
2258: IF (l_report_type = 'FEDW2' and l_value <> 0 ) OR
2259: (l_report_type = 'STW2') then
2260: SELECT pay_assignment_actions_s.nextval
2261: INTO lockingactid
2262: FROM dual;
2263: hr_utility.set_location(
2264: 'pay_us_mmref_reporting.create_assignement_act', 60);

Line 2275: UPDATE pay_assignment_actions

2271: /*IF l_report_type = 'STW2' THEN
2272: hr_utility.set_location(
2273: 'pay_us_mmref_reporting.create_assignement_act', 80);
2274: IF l_w2_box17 > 9999999.99 THEN
2275: UPDATE pay_assignment_actions
2276: SET serial_number = 999999
2277: WHERE assignment_action_id = lockingactid;
2278: END IF;
2279: END IF;*/ -- 4490252

Line 2501: FROM pay_assignment_actions paa

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

Line 2811: update pay_assignment_actions

2807: BEGIN
2808: IF p_state = 'FED' and p_error = 'Y'
2809: THEN
2810: --raise hr_utility.hr_error;
2811: update pay_assignment_actions
2812: set SERIAL_NUMBER = 'E999999999'
2813: where assignment_action_id = p_assignment_action_id;
2814: return 'Y';
2815: ELSE

Line 2846: FROM pay_assignment_actions

2842: CURSOR c_get_ye_payroll_action (c_tax_unit_id NUMBER
2843: ,c_assignment_action_id NUMBER)
2844: IS
2845: SELECT payroll_action_id
2846: FROM pay_assignment_actions
2847: WHERE tax_unit_id = c_tax_unit_id
2848: AND assignment_action_id = c_assignment_action_id;
2849:
2850: l_tax_unit_name VARCHAR2(2000);

Line 2952: pay_assignment_actions paa

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

Line 2968: ,pay_assignment_actions paa

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

Line 3035: pay_assignment_actions paa,

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

Line 3115: ,pay_assignment_actions paa

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

Line 3148: ,pay_assignment_actions paa

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

Line 3183: ,pay_assignment_actions paa

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