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 1000: 'nvl(hr_us_w2_rep.get_w2_arch_bal( '||

996: 'AND paf.effective_start_date <= ppa.effective_date '||
997: 'AND paf.effective_end_date >= ppa.start_date '||
998: 'AND paa.action_status = ''C'' '||
999: 'AND ( '||
1000: 'nvl(hr_us_w2_rep.get_w2_arch_bal( '||
1001: 'paa.assignment_action_id, '||
1002: '''A_W2_STATE_WAGES'', '||
1003: 'paa.tax_unit_id, '||
1004: 'faic.context , 2),0) > 0 '||

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

1014: 'and fdi1.user_entity_id = fai1.user_entity_id '||
1015: 'and fai1.context1 = paa.assignment_action_id '||
1016: 'and fai1.archive_item_id = faic1.archive_item_id '||
1017: 'and substr(faic1.context,1,2) = substr(faic.context,1,2) '||
1018: 'and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id, '||
1019: '''A_COUNTY_WITHHELD_PER_JD_GRE_YTD'', '||
1020: 'paa.tax_unit_id, '||
1021: 'faic1.context , 6),0) > 0) '||
1022: ') '||

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

1064: 'AND paf.effective_start_date <= ppa.effective_date '||
1065: 'AND paf.effective_end_date >= ppa.start_date '||
1066: 'AND paa.action_status = ''C'' '||
1067: 'AND ( '||
1068: 'nvl(hr_us_w2_rep.get_w2_arch_bal( '||
1069: 'paa.assignment_action_id, '||
1070: '''A_W2_STATE_WAGES'', '||
1071: 'paa.tax_unit_id, '||
1072: 'faic.context , 2),0) > 0 '||

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

1082: 'and fdi1.user_entity_id = fai1.user_entity_id '||
1083: 'and fai1.context1 = paa.assignment_action_id '||
1084: 'and fai1.archive_item_id = faic1.archive_item_id '||
1085: 'and substr(faic1.context,1,2) = substr(faic.context,1,2) '||
1086: 'and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id, '||
1087: '''A_SCHOOL_WITHHELD_PER_JD_GRE_YTD'', '||
1088: 'paa.tax_unit_id, '||
1089: 'faic1.context , 8),0) > 0) '||
1090: ') '||

Line 1138: AND nvl(hr_us_w2_rep.get_w2_arch_bal(

1134: AND fai.value = ppa1.report_qualifier
1135: AND paf.effective_start_date <= ppa.effective_date
1136: AND paf.effective_end_date >= ppa.start_date
1137: AND paa.action_status = ''C''
1138: AND nvl(hr_us_w2_rep.get_w2_arch_bal(
1139: paa.assignment_action_id,
1140: ''A_W2_STATE_WAGES'',
1141: paa.tax_unit_id,
1142: faic.context , 2),0) > 0

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

1195: paf.assignment_id,
1196: paa.tax_unit_id,
1197: paf.effective_end_date,
1198: paa.assignment_action_id,
1199: nvl(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1200: 'A_W2_STATE_WAGES',
1201: paa.tax_unit_id,
1202: faic.context , 2),0)
1203: FROM ff_archive_item_contexts faic,

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

1225: and paa.action_status = 'C'
1226: --and paa.serial_number BETWEEN to_char(p_stperson) AND to_char(p_endperson)
1227: and to_number(paa.serial_number) BETWEEN p_stperson AND p_endperson /* 6712859 */
1228: and paf.person_id BETWEEN p_stperson AND p_endperson
1229: and ( ( nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1230: 'A_W2_STATE_WAGES',
1231: paa.tax_unit_id,
1232: faic.context , 2),0) > 0 )
1233: or

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

1230: 'A_W2_STATE_WAGES',
1231: paa.tax_unit_id,
1232: faic.context , 2),0) > 0 )
1233: or
1234: ( nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1235: 'A_SIT_WITHHELD_PER_JD_GRE_YTD', /* 6809739 */
1236: paa.tax_unit_id,
1237: faic.context , 2),0) > 0) )
1238:

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

1265: paf.assignment_id,
1266: paa.tax_unit_id,
1267: paf.effective_end_date,
1268: paa.assignment_action_id,
1269: nvl(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1270: 'A_W2_STATE_WAGES',
1271: paa.tax_unit_id,
1272: faic.context , 2),0)
1273: FROM ff_archive_item_contexts faic,

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

1299: --and paa.serial_number BETWEEN to_char(p_stperson) AND to_char(p_endperson)
1300: -- and to_number(paa.serial_number) BETWEEN p_stperson AND p_endperson /* 6712859 */
1301: AND to_number(paa.serial_number) =ppr.person_id
1302: and paf.person_id BETWEEN p_stperson AND p_endperson
1303: and ( ( nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1304: 'A_W2_STATE_WAGES',
1305: paa.tax_unit_id,
1306: faic.context , 2),0) > 0 )
1307: or

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

1304: 'A_W2_STATE_WAGES',
1305: paa.tax_unit_id,
1306: faic.context , 2),0) > 0 )
1307: or
1308: ( nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1309: 'A_SIT_WITHHELD_PER_JD_GRE_YTD', /* 6809739 */
1310: paa.tax_unit_id,
1311: faic.context , 2),0) > 0) )
1312:

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

1342: paf.assignment_id,
1343: paa.tax_unit_id,
1344: paf.effective_end_date,
1345: paa.assignment_action_id,
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)
1350: FROM ff_archive_item_contexts faic,

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

1370: and paf.effective_start_date <= ppa.effective_date
1371: and paf.effective_end_date >= ppa.start_date
1372: and paa.action_status = 'C'
1373: and paf.person_id BETWEEN p_stperson AND p_endperson
1374: and (( nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1375: 'A_W2_STATE_WAGES',
1376: paa.tax_unit_id,
1377: faic.context , 2),0) > 0 )
1378: or

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

1375: 'A_W2_STATE_WAGES',
1376: paa.tax_unit_id,
1377: faic.context , 2),0) > 0 )
1378: or
1379: (nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id, /* 6809739 */
1380: 'A_SIT_WITHHELD_PER_JD_GRE_YTD',
1381: paa.tax_unit_id,
1382: faic.context , 2),0) > 0))
1383: /* Commenting it due to Performance Issue Bug# 5630156 */

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

1407: paf.assignment_id,
1408: paa.tax_unit_id,
1409: paf.effective_end_date,
1410: paa.assignment_action_id,
1411: nvl(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1412: 'A_W2_STATE_WAGES',
1413: paa.tax_unit_id,
1414: faic.context , 2),0)
1415: FROM ff_archive_item_contexts faic,

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

1438: and paf.effective_start_date <= ppa.effective_date
1439: and paf.effective_end_date >= ppa.start_date
1440: and paa.action_status = 'C'
1441: and paf.person_id =ppr.person_id
1442: and (( nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1443: 'A_W2_STATE_WAGES',
1444: paa.tax_unit_id,
1445: faic.context , 2),0) > 0 )
1446: or

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

1443: 'A_W2_STATE_WAGES',
1444: paa.tax_unit_id,
1445: faic.context , 2),0) > 0 )
1446: or
1447: (nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id, /* 6809739 */
1448: 'A_SIT_WITHHELD_PER_JD_GRE_YTD',
1449: paa.tax_unit_id,
1450: faic.context , 2),0) > 0))
1451: /* Commenting it due to Performance Issue Bug# 5630156 */

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

1480: paf.assignment_id,
1481: paa.tax_unit_id,
1482: paf.effective_end_date,
1483: paa.assignment_action_id,
1484: nvl(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1485: 'A_W2_STATE_WAGES',
1486: paa.tax_unit_id,
1487: faic.context , 2),0)
1488: FROM ff_archive_item_contexts faic,

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

1509: and paf.effective_end_date >= ppa.start_date
1510: and paa.action_status = 'C'
1511: and paf.person_id BETWEEN p_stperson AND p_endperson
1512: and ( ((
1513: nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1514: 'A_W2_STATE_WAGES',
1515: paa.tax_unit_id,
1516: faic.context , 2),0) > 0 )
1517:

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

1516: faic.context , 2),0) > 0 )
1517:
1518: or
1519: (
1520: nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id, /* 6809739 */
1521: 'A_SIT_WITHHELD_PER_JD_GRE_YTD',
1522: paa.tax_unit_id,
1523: faic.context , 2),0) > 0))
1524: OR

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

1533: and fdi1.user_entity_id = fai1.user_entity_id
1534: and fai1.context1 = paa.assignment_action_id
1535: and fai1.archive_item_id = faic1.archive_item_id
1536: and substr(faic1.context,1,2) = substr(faic.context,1,2)
1537: and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1538: 'A_COUNTY_WITHHELD_PER_JD_GRE_YTD',
1539: paa.tax_unit_id,
1540: faic1.context , 6),0) > 0)
1541: )

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

1555: paf.assignment_id,
1556: paa.tax_unit_id,
1557: paf.effective_end_date,
1558: paa.assignment_action_id,
1559: nvl(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1560: 'A_W2_STATE_WAGES',
1561: paa.tax_unit_id,
1562: faic.context , 2),0)
1563: FROM ff_archive_item_contexts faic,

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

1587: and paf.effective_end_date >= ppa.start_date
1588: and paa.action_status = 'C'
1589: and paf.person_id =ppr.person_id
1590: and ( ((
1591: nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1592: 'A_W2_STATE_WAGES',
1593: paa.tax_unit_id,
1594: faic.context , 2),0) > 0 )
1595:

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

1594: faic.context , 2),0) > 0 )
1595:
1596: or
1597: (
1598: nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id, /* 6809739 */
1599: 'A_SIT_WITHHELD_PER_JD_GRE_YTD',
1600: paa.tax_unit_id,
1601: faic.context , 2),0) > 0))
1602: OR

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

1611: and fdi1.user_entity_id = fai1.user_entity_id
1612: and fai1.context1 = paa.assignment_action_id
1613: and fai1.archive_item_id = faic1.archive_item_id
1614: and substr(faic1.context,1,2) = substr(faic.context,1,2)
1615: and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1616: 'A_COUNTY_WITHHELD_PER_JD_GRE_YTD',
1617: paa.tax_unit_id,
1618: faic1.context , 6),0) > 0)
1619: )

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

1636: paf.assignment_id,
1637: paa.tax_unit_id,
1638: paf.effective_end_date,
1639: paa.assignment_action_id,
1640: nvl(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1641: 'A_W2_STATE_WAGES',
1642: paa.tax_unit_id,
1643: faic.context , 2),0)
1644: FROM ff_archive_item_contexts faic,

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

1665: and paf.effective_end_date >= ppa.start_date
1666: and paa.action_status = 'C'
1667: and paf.person_id BETWEEN p_stperson AND p_endperson
1668: and ( ((
1669: nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1670: 'A_W2_STATE_WAGES',
1671: paa.tax_unit_id,
1672: faic.context , 2),0) > 0 )
1673: or

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

1671: paa.tax_unit_id,
1672: faic.context , 2),0) > 0 )
1673: or
1674: (
1675: nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id, /* 6809739 */
1676: 'A_SIT_WITHHELD_PER_JD_GRE_YTD',
1677: paa.tax_unit_id,
1678: faic.context , 2),0) > 0) )
1679: OR

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

1688: and fdi1.user_entity_id = fai1.user_entity_id
1689: and fai1.context1 = paa.assignment_action_id
1690: and fai1.archive_item_id = faic1.archive_item_id
1691: and substr(faic1.context,1,2) = substr(faic.context,1,2)
1692: and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1693: 'A_SCHOOL_WITHHELD_PER_JD_GRE_YTD',
1694: paa.tax_unit_id,
1695: faic1.context , 8),0) > 0)
1696: )

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

1710: paf.assignment_id,
1711: paa.tax_unit_id,
1712: paf.effective_end_date,
1713: paa.assignment_action_id,
1714: nvl(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1715: 'A_W2_STATE_WAGES',
1716: paa.tax_unit_id,
1717: faic.context , 2),0)
1718: FROM ff_archive_item_contexts faic,

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

1742: and paf.effective_end_date >= ppa.start_date
1743: and paa.action_status = 'C'
1744: and paf.person_id =ppr.person_id
1745: and ( ((
1746: nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1747: 'A_W2_STATE_WAGES',
1748: paa.tax_unit_id,
1749: faic.context , 2),0) > 0 )
1750: or

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

1748: paa.tax_unit_id,
1749: faic.context , 2),0) > 0 )
1750: or
1751: (
1752: nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id, /* 6809739 */
1753: 'A_SIT_WITHHELD_PER_JD_GRE_YTD',
1754: paa.tax_unit_id,
1755: faic.context , 2),0) > 0) )
1756: OR

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

1765: and fdi1.user_entity_id = fai1.user_entity_id
1766: and fai1.context1 = paa.assignment_action_id
1767: and fai1.archive_item_id = faic1.archive_item_id
1768: and substr(faic1.context,1,2) = substr(faic.context,1,2)
1769: and nvL(hr_us_w2_rep.get_w2_arch_bal(paa.assignment_action_id,
1770: 'A_SCHOOL_WITHHELD_PER_JD_GRE_YTD',
1771: paa.tax_unit_id,
1772: faic1.context , 8),0) > 0)
1773: )

Line 2873: hr_us_w2_rep.get_w2_tax_unit_item (tax_unit_id,

2869: FETCH c_get_ye_payroll_action INTO l_payroll_action_id;
2870: CLOSE c_get_ye_payroll_action;
2871: IF l_payroll_action_id <> 0 THEN
2872: l_tax_jurisdiction_code :=
2873: hr_us_w2_rep.get_w2_tax_unit_item (tax_unit_id,
2874: l_payroll_action_id,
2875: 'A_LC_W2_REPORTING_RULES_ORG_TAX_JURISDICTION');
2876: END IF;
2877: p_tax_jd_code := l_tax_jurisdiction_code;