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 HR_US_W2_REP

Line 975: 'nvl(hr_us_w2_rep.get_w2_arch_bal( '||

971: 'AND paf.effective_start_date <= ppa.effective_date '||
972: 'AND paf.effective_end_date >= ppa.start_date '||
973: 'AND paa.action_status = ''C'' '||
974: 'AND ( '||
975: 'nvl(hr_us_w2_rep.get_w2_arch_bal( '||
976: 'paa.assignment_action_id, '||
977: '''A_W2_STATE_WAGES'', '||
978: 'paa.tax_unit_id, '||
979: 'faic.context , 2),0) > 0 '||

Line 993: 'and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id, '||

989: 'and fdi1.user_entity_id = fai1.user_entity_id '||
990: 'and fai1.context1 = paa.assignment_action_id '||
991: 'and fai1.archive_item_id = faic1.archive_item_id '||
992: 'and substr(faic1.context,1,2) = substr(faic.context,1,2) '||
993: 'and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id, '||
994: '''A_COUNTY_WITHHELD_PER_JD_GRE_YTD'', '||
995: 'paa.tax_unit_id, '||
996: 'faic1.context , 6),0) > 0) '||
997: ') '||

Line 1043: 'nvl(hr_us_w2_rep.get_w2_arch_bal( '||

1039: 'AND paf.effective_start_date <= ppa.effective_date '||
1040: 'AND paf.effective_end_date >= ppa.start_date '||
1041: 'AND paa.action_status = ''C'' '||
1042: 'AND ( '||
1043: 'nvl(hr_us_w2_rep.get_w2_arch_bal( '||
1044: 'paa.assignment_action_id, '||
1045: '''A_W2_STATE_WAGES'', '||
1046: 'paa.tax_unit_id, '||
1047: 'faic.context , 2),0) > 0 '||

Line 1061: 'and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id, '||

1057: 'and fdi1.user_entity_id = fai1.user_entity_id '||
1058: 'and fai1.context1 = paa.assignment_action_id '||
1059: 'and fai1.archive_item_id = faic1.archive_item_id '||
1060: 'and substr(faic1.context,1,2) = substr(faic.context,1,2) '||
1061: 'and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id, '||
1062: '''A_SCHOOL_WITHHELD_PER_JD_GRE_YTD'', '||
1063: 'paa.tax_unit_id, '||
1064: 'faic1.context , 8),0) > 0) '||
1065: ') '||

Line 1113: AND nvl(hr_us_w2_rep.get_w2_arch_bal(

1109: AND fai.value = ppa1.report_qualifier
1110: AND paf.effective_start_date <= ppa.effective_date
1111: AND paf.effective_end_date >= ppa.start_date
1112: AND paa.action_status = ''C''
1113: AND nvl(hr_us_w2_rep.get_w2_arch_bal(
1114: paa.assignment_action_id,
1115: ''A_W2_STATE_WAGES'',
1116: paa.tax_unit_id,
1117: faic.context , 2),0) > 0

Line 1174: nvl(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,

1170: paf.assignment_id,
1171: paa.tax_unit_id,
1172: paf.effective_end_date,
1173: paa.assignment_action_id,
1174: nvl(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1175: 'A_W2_STATE_WAGES',
1176: paa.tax_unit_id,
1177: faic.context , 2),0)
1178: FROM ff_archive_item_contexts faic,

Line 1204: and ( ( nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,

1200: and paa.action_status = 'C'
1201: --and paa.serial_number BETWEEN to_char(p_stperson) AND to_char(p_endperson)
1202: and to_number(paa.serial_number) BETWEEN p_stperson AND p_endperson /* 6712859 */
1203: and paf.person_id BETWEEN p_stperson AND p_endperson
1204: and ( ( nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1205: 'A_W2_STATE_WAGES',
1206: paa.tax_unit_id,
1207: faic.context , 2),0) > 0 )
1208: or

Line 1209: ( nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,

1205: 'A_W2_STATE_WAGES',
1206: paa.tax_unit_id,
1207: faic.context , 2),0) > 0 )
1208: or
1209: ( nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1210: 'A_SIT_WITHHELD_PER_JD_GRE_YTD', /* 6809739 */
1211: paa.tax_unit_id,
1212: faic.context , 2),0) > 0) )
1213:

Line 1246: nvl(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,

1242: paf.assignment_id,
1243: paa.tax_unit_id,
1244: paf.effective_end_date,
1245: paa.assignment_action_id,
1246: nvl(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1247: 'A_W2_STATE_WAGES',
1248: paa.tax_unit_id,
1249: faic.context , 2),0)
1250: FROM ff_archive_item_contexts faic,

Line 1274: and (( nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,

1270: and paf.effective_start_date <= ppa.effective_date
1271: and paf.effective_end_date >= ppa.start_date
1272: and paa.action_status = 'C'
1273: and paf.person_id BETWEEN p_stperson AND p_endperson
1274: and (( nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1275: 'A_W2_STATE_WAGES',
1276: paa.tax_unit_id,
1277: faic.context , 2),0) > 0 )
1278: or

Line 1279: (nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id, /* 6809739 */

1275: 'A_W2_STATE_WAGES',
1276: paa.tax_unit_id,
1277: faic.context , 2),0) > 0 )
1278: or
1279: (nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id, /* 6809739 */
1280: 'A_SIT_WITHHELD_PER_JD_GRE_YTD',
1281: paa.tax_unit_id,
1282: faic.context , 2),0) > 0))
1283: /* Commenting it due to Performance Issue Bug# 5630156 */

Line 1317: nvl(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,

1313: paf.assignment_id,
1314: paa.tax_unit_id,
1315: paf.effective_end_date,
1316: paa.assignment_action_id,
1317: nvl(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1318: 'A_W2_STATE_WAGES',
1319: paa.tax_unit_id,
1320: faic.context , 2),0)
1321: FROM ff_archive_item_contexts faic,

Line 1346: nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,

1342: and paf.effective_end_date >= ppa.start_date
1343: and paa.action_status = 'C'
1344: and paf.person_id BETWEEN p_stperson AND p_endperson
1345: and ( ((
1346: nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1347: 'A_W2_STATE_WAGES',
1348: paa.tax_unit_id,
1349: faic.context , 2),0) > 0 )
1350:

Line 1353: nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id, /* 6809739 */

1349: faic.context , 2),0) > 0 )
1350:
1351: or
1352: (
1353: nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id, /* 6809739 */
1354: 'A_SIT_WITHHELD_PER_JD_GRE_YTD',
1355: paa.tax_unit_id,
1356: faic.context , 2),0) > 0))
1357: OR

Line 1370: and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,

1366: and fdi1.user_entity_id = fai1.user_entity_id
1367: and fai1.context1 = paa.assignment_action_id
1368: and fai1.archive_item_id = faic1.archive_item_id
1369: and substr(faic1.context,1,2) = substr(faic.context,1,2)
1370: and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1371: 'A_COUNTY_WITHHELD_PER_JD_GRE_YTD',
1372: paa.tax_unit_id,
1373: faic1.context , 6),0) > 0)
1374: )

Line 1395: nvl(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,

1391: paf.assignment_id,
1392: paa.tax_unit_id,
1393: paf.effective_end_date,
1394: paa.assignment_action_id,
1395: nvl(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1396: 'A_W2_STATE_WAGES',
1397: paa.tax_unit_id,
1398: faic.context , 2),0)
1399: FROM ff_archive_item_contexts faic,

Line 1424: nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,

1420: and paf.effective_end_date >= ppa.start_date
1421: and paa.action_status = 'C'
1422: and paf.person_id BETWEEN p_stperson AND p_endperson
1423: and ( ((
1424: nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1425: 'A_W2_STATE_WAGES',
1426: paa.tax_unit_id,
1427: faic.context , 2),0) > 0 )
1428: or

Line 1430: nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id, /* 6809739 */

1426: paa.tax_unit_id,
1427: faic.context , 2),0) > 0 )
1428: or
1429: (
1430: nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id, /* 6809739 */
1431: 'A_SIT_WITHHELD_PER_JD_GRE_YTD',
1432: paa.tax_unit_id,
1433: faic.context , 2),0) > 0) )
1434: OR

Line 1447: and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,

1443: and fdi1.user_entity_id = fai1.user_entity_id
1444: and fai1.context1 = paa.assignment_action_id
1445: and fai1.archive_item_id = faic1.archive_item_id
1446: and substr(faic1.context,1,2) = substr(faic.context,1,2)
1447: and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1448: 'A_SCHOOL_WITHHELD_PER_JD_GRE_YTD',
1449: paa.tax_unit_id,
1450: faic1.context , 8),0) > 0)
1451: )

Line 2381: hr_us_w2_rep.get_w2_tax_unit_item (tax_unit_id,

2377: FETCH c_get_ye_payroll_action INTO l_payroll_action_id;
2378: CLOSE c_get_ye_payroll_action;
2379: IF l_payroll_action_id <> 0 THEN
2380: l_tax_jurisdiction_code :=
2381: hr_us_w2_rep.get_w2_tax_unit_item (tax_unit_id,
2382: l_payroll_action_id,
2383: 'A_LC_W2_REPORTING_RULES_ORG_TAX_JURISDICTION');
2384: END IF;
2385: p_tax_jd_code := l_tax_jurisdiction_code;