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_ITEMS

Line 437: ff_archive_items target,

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
439: WHERE target.context1 = to_char(cp_payroll_action_id)
440: /* context of payroll_action_id */
441: AND fdi.user_name = 'A_FIPS_CODE_JD'

Line 978: 'ff_archive_items fai, '||

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, '||
982: 'per_all_assignments_f paf, '||

Line 1008: 'ff_archive_items fai1, '||

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

Line 1046: 'ff_archive_items fai, '||

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, '||
1050: 'per_all_assignments_f paf, '||

Line 1076: 'ff_archive_items fai1, '||

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

Line 1116: ff_archive_items fai,

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,
1120: per_all_assignments_f paf,

Line 1204: ff_archive_items fai,

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,
1208: per_all_assignments_f paf,

Line 1274: ff_archive_items fai,

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,
1278: per_all_assignments_f paf,

Line 1351: ff_archive_items fai,

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,
1355: per_all_assignments_f paf,

Line 1416: ff_archive_items fai,

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,
1420: per_all_assignments_f paf,

Line 1489: ff_archive_items fai,

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,
1493: per_all_assignments_f paf,

Line 1527: ff_archive_items fai1,

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

Line 1564: ff_archive_items fai,

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,
1568: per_all_assignments_f paf,

Line 1605: ff_archive_items fai1,

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

Line 1645: ff_archive_items fai,

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,
1649: per_all_assignments_f paf,

Line 1682: ff_archive_items fai1,

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

Line 1719: ff_archive_items fai,

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,
1723: per_all_assignments_f paf,

Line 1759: ff_archive_items fai1,

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

Line 1856: ff_archive_items fai,

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
1860: and fc.context_name = 'TAX_UNIT_ID'

Line 1872: ff_archive_items fai,

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',
1876: 'A_SUPPLEMENTAL_EARNINGS_FOR_FIT_SUBJECT_TO_TAX_PER_GRE_YTD',

Line 2370: FROM ff_archive_items fai,

2366: FOR c_id IN c_get_user_entity_id LOOP
2367:
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

Line 2420: FROM ff_archive_items fai,

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

Line 2530: ff_archive_items target,

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
2532: WHERE target.context1 = to_char(cp_payroll_action_id)
2533: /* context of payroll_action_id */
2534: and fdi.user_name = 'A_STATE_TAX_RULES_ORG_SIT_COMPANY_STATE_ID'

Line 2684: ff_archive_items fai

2680: FROM DUAL
2681: WHERE EXISTS
2682: (SELECT NULL
2683: FROM pay_payroll_actions ppa,
2684: ff_archive_items fai
2685: WHERE ppa.report_type = 'YREND'
2686: AND ppa.report_qualifier = 'FED'
2687: AND ppa.report_category = 'RT'
2688: AND ppa.effective_date = p_effective_date

Line 2770: ff_archive_items fai

2766: FROM DUAL
2767: WHERE EXISTS
2768: (SELECT NULL
2769: FROM pay_payroll_actions ppa,
2770: ff_archive_items fai
2771: WHERE ppa.report_type = 'YREND'
2772: AND ppa.report_qualifier = 'FED'
2773: AND ppa.report_category = 'RT'
2774: AND ppa.effective_date = p_effective_date

Line 3032: FROM ff_archive_items fai,

3028: 'A_SS_ER_W11_TAXABLE_PER_GRE_YTD', nvl(sum(to_number(value)),0),
3029: 'A_W2_HEALTH_COVERAGE_PER_GRE_YTD', nvl(sum(to_number(value)),0), --Bug 13497022
3030: 'A_W2_ROTH_457B_PER_GRE_YTD', nvl(sum(to_number(value)),0) --Bug 13497022
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

Line 3114: ,ff_archive_items fai

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
3118: ,ff_user_entities fue

Line 3147: ,ff_archive_items fai

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
3151: ,ff_user_entities fue

Line 3172: from ff_user_entities fai1, ff_archive_items fue1

3168: 'A_SIT_PRE_TAX_REDNS_PER_JD_GRE_YTD' ,
3169: 'A_W2_GROUP_TERM_LIFE_PER_GRE_YTD' )
3170: and paa.action_status = 'C'
3171: and exists (select 'Y'
3172: from ff_user_entities fai1, ff_archive_items fue1
3173: where fai1.user_entity_name = 'A_STATE_ABBREV'
3174: and fai1.user_entity_id = fue1.user_entity_id
3175: and fue1.value = 'PR'
3176: and fai1.user_entity_id = fue1.user_entity_id

Line 3184: ,ff_archive_items fai

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