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 FF_ARCHIVE_ITEM_CONTEXTS

Line 433: FROM ff_archive_item_contexts con3,

429: /* cursor to check if the state tax Rules have been added or Not. */
430: CURSOR c_chk_archive_state_code(cp_tax_unit_id number,cp_payroll_action_id number)
431: IS
432: SELECT 'Y'
433: FROM ff_archive_item_contexts con3,
434: ff_archive_item_contexts con2,
435: ff_contexts fc3,
436: ff_contexts fc2,
437: ff_archive_items target,

Line 434: ff_archive_item_contexts con2,

430: CURSOR c_chk_archive_state_code(cp_tax_unit_id number,cp_payroll_action_id number)
431: IS
432: SELECT 'Y'
433: FROM ff_archive_item_contexts con3,
434: ff_archive_item_contexts con2,
435: ff_contexts fc3,
436: ff_contexts fc2,
437: ff_archive_items target,
438: ff_database_items fdi

Line 977: 'FROM ff_archive_item_contexts faic, '||

973: 30);
974: ELSIF p_report_type = 'STW2' and p_state_abbrev = 'IN' THEN
975: p_sqlstr := 'SELECT DISTINCT '||
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, '||

Line 1009: 'ff_archive_item_contexts faic1, '||

1005: 'OR '||
1006: 'exists (select ''x'' '||
1007: 'from ff_contexts fc1, '||
1008: 'ff_archive_items fai1, '||
1009: 'ff_archive_item_contexts faic1, '||
1010: 'ff_database_items fdi1 '||
1011: 'where fc1.context_name = ''JURISDICTION_CODE'' '||
1012: 'and fc1.context_id = faic1.context_id '||
1013: 'and fdi1.user_name = ''A_COUNTY_WITHHELD_PER_JD_GRE_YTD'' '||

Line 1045: 'FROM ff_archive_item_contexts faic, '||

1041: 40);
1042: ELSIF p_report_type = 'STW2' and p_state_abbrev = 'OH' THEN
1043: p_sqlstr := 'SELECT DISTINCT '||
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, '||

Line 1077: 'ff_archive_item_contexts faic1, '||

1073: 'OR '||
1074: 'exists (select ''x'' '||
1075: 'from ff_contexts fc1, '||
1076: 'ff_archive_items fai1, '||
1077: 'ff_archive_item_contexts faic1, '||
1078: 'ff_database_items fdi1 '||
1079: 'where fc1.context_name = ''JURISDICTION_CODE'' '||
1080: 'and fc1.context_id = faic1.context_id '||
1081: 'and fdi1.user_name = ''A_SCHOOL_WITHHELD_PER_JD_GRE_YTD'' '||

Line 1115: FROM ff_archive_item_contexts faic,

1111: ELSIF p_report_type = 'STW2' THEN
1112: p_sqlstr := '
1113: SELECT DISTINCT
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,

Line 1203: FROM ff_archive_item_contexts faic,

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,
1204: ff_archive_items fai,
1205: ff_database_items fdi,
1206: pay_assignment_actions paa,
1207: pay_payroll_actions ppa,

Line 1273: FROM ff_archive_item_contexts faic,

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,
1274: ff_archive_items fai,
1275: ff_database_items fdi,
1276: pay_assignment_actions paa,
1277: pay_payroll_actions ppa,

Line 1350: FROM ff_archive_item_contexts faic,

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,
1351: ff_archive_items fai,
1352: ff_database_items fdi,
1353: pay_assignment_actions paa,
1354: pay_payroll_actions ppa,

Line 1415: FROM ff_archive_item_contexts faic,

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,
1416: ff_archive_items fai,
1417: ff_database_items fdi,
1418: pay_assignment_actions paa,
1419: pay_payroll_actions ppa,

Line 1488: FROM ff_archive_item_contexts faic,

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,
1489: ff_archive_items fai,
1490: ff_database_items fdi,
1491: pay_assignment_actions paa,
1492: pay_payroll_actions ppa,

Line 1528: ff_archive_item_contexts faic1,

1524: OR
1525: exists (select 'x'
1526: from ff_contexts fc1,
1527: ff_archive_items fai1,
1528: ff_archive_item_contexts faic1,
1529: ff_database_items fdi1
1530: where fc1.context_name = 'JURISDICTION_CODE'
1531: and fc1.context_id = faic1.context_id
1532: and fdi1.user_name = 'A_COUNTY_WITHHELD_PER_JD_GRE_YTD'

Line 1563: FROM ff_archive_item_contexts faic,

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,
1564: ff_archive_items fai,
1565: ff_database_items fdi,
1566: pay_assignment_actions paa,
1567: pay_payroll_actions ppa,

Line 1606: ff_archive_item_contexts faic1,

1602: OR
1603: exists (select 'x'
1604: from ff_contexts fc1,
1605: ff_archive_items fai1,
1606: ff_archive_item_contexts faic1,
1607: ff_database_items fdi1
1608: where fc1.context_name = 'JURISDICTION_CODE'
1609: and fc1.context_id = faic1.context_id
1610: and fdi1.user_name = 'A_COUNTY_WITHHELD_PER_JD_GRE_YTD'

Line 1644: FROM ff_archive_item_contexts faic,

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,
1645: ff_archive_items fai,
1646: ff_database_items fdi,
1647: pay_assignment_actions paa,
1648: pay_payroll_actions ppa,

Line 1683: ff_archive_item_contexts faic1,

1679: OR
1680: exists (select 'x'
1681: from ff_contexts fc1,
1682: ff_archive_items fai1,
1683: ff_archive_item_contexts faic1,
1684: ff_database_items fdi1
1685: where fc1.context_name = 'JURISDICTION_CODE'
1686: and fc1.context_id = faic1.context_id
1687: and fdi1.user_name = 'A_SCHOOL_WITHHELD_PER_JD_GRE_YTD'

Line 1718: FROM ff_archive_item_contexts faic,

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,
1719: ff_archive_items fai,
1720: ff_database_items fdi,
1721: pay_assignment_actions paa,
1722: pay_payroll_actions ppa,

Line 1760: ff_archive_item_contexts faic1,

1756: OR
1757: exists (select 'x'
1758: from ff_contexts fc1,
1759: ff_archive_items fai1,
1760: ff_archive_item_contexts faic1,
1761: ff_database_items fdi1
1762: where fc1.context_name = 'JURISDICTION_CODE'
1763: and fc1.context_id = faic1.context_id
1764: and fdi1.user_name = 'A_SCHOOL_WITHHELD_PER_JD_GRE_YTD'

Line 1855: from ff_archive_item_contexts faic,

1851: cursor csr_get_fed_wages(p_user_name varchar2,
1852: p_assignment_action_id number,
1853: p_tax_unit_id number) is
1854: select to_number(fai.value) value
1855: from ff_archive_item_contexts faic,
1856: ff_archive_items fai,
1857: ff_contexts fc,
1858: ff_database_items fdi
1859: where fdi.user_name = p_user_name

Line 1871: from ff_archive_item_contexts faic,

1867:
1868: cursor csr_get_fit_sub_wages(p_assignment_action_id number,
1869: p_tax_unit_id number) is
1870: select to_number(fai.value) value
1871: from ff_archive_item_contexts faic,
1872: ff_archive_items fai,
1873: ff_contexts fc,
1874: ff_database_items fdi
1875: where fdi.user_name IN ('A_REGULAR_EARNINGS_PER_GRE_YTD',

Line 2372: ff_archive_item_contexts faic

2368: SELECT value
2369: INTO l_ein_val
2370: FROM ff_archive_items fai,
2371: ff_contexts fc,
2372: ff_archive_item_contexts faic
2373: WHERE fai.context1 = to_char(p_pactid)
2374: AND user_entity_id = c_id.user_entity_id
2375: AND faic.archive_item_id = fai.archive_item_id
2376: AND faic.context = to_char(l_gre)

Line 2421: ff_archive_item_contexts faic,

2417: CURSOR c_get_state_id
2418: IS
2419: SELECT value
2420: FROM ff_archive_items fai,
2421: ff_archive_item_contexts faic,
2422: ff_archive_item_contexts faic1
2423: WHERE context1 = to_char(p_pactid)
2424: AND user_entity_id = l_sit_state_id
2425: AND faic.archive_item_id = fai.archive_item_id

Line 2422: ff_archive_item_contexts faic1

2418: IS
2419: SELECT value
2420: FROM ff_archive_items fai,
2421: ff_archive_item_contexts faic,
2422: ff_archive_item_contexts faic1
2423: WHERE context1 = to_char(p_pactid)
2424: AND user_entity_id = l_sit_state_id
2425: AND faic.archive_item_id = fai.archive_item_id
2426: AND faic1.archive_item_id = fai.archive_item_id

Line 2526: ff_archive_item_contexts con3,

2522: cp_state_Code varchar2 )
2523: IS
2524: SELECT target.value
2525: FROM
2526: ff_archive_item_contexts con3,
2527: ff_archive_item_contexts con2,
2528: ff_contexts fc3,
2529: ff_contexts fc2,
2530: ff_archive_items target,

Line 2527: ff_archive_item_contexts con2,

2523: IS
2524: SELECT target.value
2525: FROM
2526: ff_archive_item_contexts con3,
2527: ff_archive_item_contexts con2,
2528: ff_contexts fc3,
2529: ff_contexts fc2,
2530: ff_archive_items target,
2531: ff_database_items fdi

Line 3113: FROM ff_archive_item_contexts faic

3109: 'A_SIT_SUBJ_WHABLE_PER_JD_GRE_YTD', nvl(sum(round(to_number(value),2)),0) ,
3110: 'A_SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD', nvl(sum(round(to_number(value),2)),0) ,
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

Line 3146: FROM ff_archive_item_contexts faic

3142: 'A_SIT_SUBJ_WHABLE_PER_JD_GRE_YTD', nvl(sum(round(to_number(value),2)),0) ,
3143: 'A_SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD', nvl(sum(round(to_number(value),2)),0) ,
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