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 422: ff_archive_items target,

418: FROM ff_archive_item_contexts con3,
419: ff_archive_item_contexts con2,
420: ff_contexts fc3,
421: ff_contexts fc2,
422: ff_archive_items target,
423: ff_database_items fdi
424: WHERE target.context1 = to_char(cp_payroll_action_id)
425: /* context of payroll_action_id */
426: AND fdi.user_name = 'A_FIPS_CODE_JD'

Line 953: 'ff_archive_items fai, '||

949: ELSIF p_report_type = 'STW2' and p_state_abbrev = 'IN' THEN
950: p_sqlstr := 'SELECT DISTINCT '||
951: 'to_number(paa.serial_number) '||
952: 'FROM ff_archive_item_contexts faic, '||
953: 'ff_archive_items fai, '||
954: 'ff_database_items fdi, '||
955: 'pay_assignment_actions paa, '||
956: 'pay_payroll_actions ppa, '||
957: 'per_all_assignments_f paf, '||

Line 983: 'ff_archive_items fai1, '||

979: 'faic.context , 2),0) > 0 '||
980: 'OR '||
981: 'exists (select ''x'' '||
982: 'from ff_contexts fc1, '||
983: 'ff_archive_items fai1, '||
984: 'ff_archive_item_contexts faic1, '||
985: 'ff_database_items fdi1 '||
986: 'where fc1.context_name = ''JURISDICTION_CODE'' '||
987: 'and fc1.context_id = faic1.context_id '||

Line 1021: 'ff_archive_items fai, '||

1017: ELSIF p_report_type = 'STW2' and p_state_abbrev = 'OH' THEN
1018: p_sqlstr := 'SELECT DISTINCT '||
1019: 'to_number(paa.serial_number) '||
1020: 'FROM ff_archive_item_contexts faic, '||
1021: 'ff_archive_items fai, '||
1022: 'ff_database_items fdi, '||
1023: 'pay_assignment_actions paa, '||
1024: 'pay_payroll_actions ppa, '||
1025: 'per_all_assignments_f paf, '||

Line 1051: 'ff_archive_items fai1, '||

1047: 'faic.context , 2),0) > 0 '||
1048: 'OR '||
1049: 'exists (select ''x'' '||
1050: 'from ff_contexts fc1, '||
1051: 'ff_archive_items fai1, '||
1052: 'ff_archive_item_contexts faic1, '||
1053: 'ff_database_items fdi1 '||
1054: 'where fc1.context_name = ''JURISDICTION_CODE'' '||
1055: 'and fc1.context_id = faic1.context_id '||

Line 1091: ff_archive_items fai,

1087: p_sqlstr := '
1088: SELECT DISTINCT
1089: to_number(paa.serial_number)
1090: FROM ff_archive_item_contexts faic,
1091: ff_archive_items fai,
1092: ff_database_items fdi,
1093: pay_assignment_actions paa,
1094: pay_payroll_actions ppa,
1095: per_all_assignments_f paf,

Line 1179: ff_archive_items fai,

1175: 'A_W2_STATE_WAGES',
1176: paa.tax_unit_id,
1177: faic.context , 2),0)
1178: FROM ff_archive_item_contexts faic,
1179: ff_archive_items fai,
1180: ff_database_items fdi,
1181: pay_assignment_actions paa,
1182: pay_payroll_actions ppa,
1183: per_all_assignments_f paf,

Line 1251: ff_archive_items fai,

1247: 'A_W2_STATE_WAGES',
1248: paa.tax_unit_id,
1249: faic.context , 2),0)
1250: FROM ff_archive_item_contexts faic,
1251: ff_archive_items fai,
1252: ff_database_items fdi,
1253: pay_assignment_actions paa,
1254: pay_payroll_actions ppa,
1255: per_all_assignments_f paf,

Line 1322: ff_archive_items fai,

1318: 'A_W2_STATE_WAGES',
1319: paa.tax_unit_id,
1320: faic.context , 2),0)
1321: FROM ff_archive_item_contexts faic,
1322: ff_archive_items fai,
1323: ff_database_items fdi,
1324: pay_assignment_actions paa,
1325: pay_payroll_actions ppa,
1326: per_all_assignments_f paf,

Line 1360: ff_archive_items fai1,

1356: faic.context , 2),0) > 0))
1357: OR
1358: exists (select 'x'
1359: from ff_contexts fc1,
1360: ff_archive_items fai1,
1361: ff_archive_item_contexts faic1,
1362: ff_database_items fdi1
1363: where fc1.context_name = 'JURISDICTION_CODE'
1364: and fc1.context_id = faic1.context_id

Line 1400: ff_archive_items fai,

1396: 'A_W2_STATE_WAGES',
1397: paa.tax_unit_id,
1398: faic.context , 2),0)
1399: FROM ff_archive_item_contexts faic,
1400: ff_archive_items fai,
1401: ff_database_items fdi,
1402: pay_assignment_actions paa,
1403: pay_payroll_actions ppa,
1404: per_all_assignments_f paf,

Line 1437: ff_archive_items fai1,

1433: faic.context , 2),0) > 0) )
1434: OR
1435: exists (select 'x'
1436: from ff_contexts fc1,
1437: ff_archive_items fai1,
1438: ff_archive_item_contexts faic1,
1439: ff_database_items fdi1
1440: where fc1.context_name = 'JURISDICTION_CODE'
1441: and fc1.context_id = faic1.context_id

Line 1498: ff_archive_items fai,

1494: p_assignment_action_id number,
1495: p_tax_unit_id number) is
1496: select to_number(fai.value) value
1497: from ff_archive_item_contexts faic,
1498: ff_archive_items fai,
1499: ff_contexts fc,
1500: ff_database_items fdi
1501: where fdi.user_name = p_user_name
1502: and fc.context_name = 'TAX_UNIT_ID'

Line 1514: ff_archive_items fai,

1510: cursor csr_get_fit_sub_wages(p_assignment_action_id number,
1511: p_tax_unit_id number) is
1512: select to_number(fai.value) value
1513: from ff_archive_item_contexts faic,
1514: ff_archive_items fai,
1515: ff_contexts fc,
1516: ff_database_items fdi
1517: where fdi.user_name IN ('A_REGULAR_EARNINGS_PER_GRE_YTD',
1518: 'A_SUPPLEMENTAL_EARNINGS_FOR_FIT_SUBJECT_TO_TAX_PER_GRE_YTD',

Line 1878: FROM ff_archive_items fai,

1874: FOR c_id IN c_get_user_entity_id LOOP
1875:
1876: SELECT value
1877: INTO l_ein_val
1878: FROM ff_archive_items fai,
1879: ff_contexts fc,
1880: ff_archive_item_contexts faic
1881: WHERE fai.context1 = to_char(p_pactid)
1882: AND user_entity_id = c_id.user_entity_id

Line 1928: FROM ff_archive_items fai,

1924:
1925: CURSOR c_get_state_id
1926: IS
1927: SELECT value
1928: FROM ff_archive_items fai,
1929: ff_archive_item_contexts faic,
1930: ff_archive_item_contexts faic1
1931: WHERE context1 = to_char(p_pactid)
1932: AND user_entity_id = l_sit_state_id

Line 2038: ff_archive_items target,

2034: ff_archive_item_contexts con3,
2035: ff_archive_item_contexts con2,
2036: ff_contexts fc3,
2037: ff_contexts fc2,
2038: ff_archive_items target,
2039: ff_database_items fdi
2040: WHERE target.context1 = to_char(cp_payroll_action_id)
2041: /* context of payroll_action_id */
2042: and fdi.user_name = 'A_STATE_TAX_RULES_ORG_SIT_COMPANY_STATE_ID'

Line 2192: ff_archive_items fai

2188: FROM DUAL
2189: WHERE EXISTS
2190: (SELECT NULL
2191: FROM pay_payroll_actions ppa,
2192: ff_archive_items fai
2193: WHERE ppa.report_type = 'YREND'
2194: AND ppa.report_qualifier = 'FED'
2195: AND ppa.report_category = 'RT'
2196: AND ppa.effective_date = p_effective_date

Line 2278: ff_archive_items fai

2274: FROM DUAL
2275: WHERE EXISTS
2276: (SELECT NULL
2277: FROM pay_payroll_actions ppa,
2278: ff_archive_items fai
2279: WHERE ppa.report_type = 'YREND'
2280: AND ppa.report_qualifier = 'FED'
2281: AND ppa.report_category = 'RT'
2282: AND ppa.effective_date = p_effective_date

Line 2532: FROM ff_archive_items fai,

2528: 'A_TERRITORY_TAXABLE_TIPS_PER_GRE_YTD', nvl(sum(round(to_number(value),2)),0) ,
2529: 'A_W2_ROTH_401K_PER_GRE_YTD', nvl(sum(to_number(value)),0) ,
2530: 'A_W2_ROTH_403B_PER_GRE_YTD', nvl(sum(to_number(value)),0)
2531: ) val
2532: FROM ff_archive_items fai,
2533: pay_action_interlocks pai,
2534: pay_payroll_actions ppa,
2535: pay_assignment_actions paa,
2536: ff_user_entities fue

Line 2608: ,ff_archive_items fai

2604: 'A_SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD', nvl(sum(round(to_number(value),2)),0) ,
2605: 'A_SIT_PRE_TAX_REDNS_PER_JD_GRE_YTD', nvl(sum(round(to_number(value),2)),0)
2606: ) val
2607: FROM ff_archive_item_contexts faic
2608: ,ff_archive_items fai
2609: ,pay_assignment_actions paa
2610: ,pay_payroll_actions ppa
2611: ,pay_action_interlocks pai
2612: ,ff_user_entities fue

Line 2641: ,ff_archive_items fai

2637: 'A_SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD', nvl(sum(round(to_number(value),2)),0) ,
2638: 'A_SIT_PRE_TAX_REDNS_PER_JD_GRE_YTD', nvl(sum(round(to_number(value),2)),0),
2639: 'A_W2_GROUP_TERM_LIFE_PER_GRE_YTD', nvl(sum(round(to_number(value),2)),0)) val
2640: FROM ff_archive_item_contexts faic
2641: ,ff_archive_items fai
2642: ,pay_assignment_actions paa
2643: ,pay_payroll_actions ppa
2644: ,pay_action_interlocks pai
2645: ,ff_user_entities fue

Line 2666: from ff_user_entities fai1, ff_archive_items fue1

2662: 'A_SIT_PRE_TAX_REDNS_PER_JD_GRE_YTD' ,
2663: 'A_W2_GROUP_TERM_LIFE_PER_GRE_YTD' )
2664: and paa.action_status = 'C'
2665: and exists (select 'Y'
2666: from ff_user_entities fai1, ff_archive_items fue1
2667: where fai1.user_entity_name = 'A_STATE_ABBREV'
2668: and fai1.user_entity_id = fue1.user_entity_id
2669: and fue1.value = 'PR'
2670: and fai1.user_entity_id = fue1.user_entity_id

Line 2678: ,ff_archive_items fai

2674: CURSOR c_ro_count ( cp_tax_unit_id number) IS
2675: select count(*)
2676: from pay_payroll_actions ppa
2677: ,pay_assignment_actions paa
2678: ,ff_archive_items fai
2679: where ppa.report_type = 'W2'
2680: and ppa.report_qualifier = 'FED'
2681: and ppa.report_category = 'MT'
2682: and effective_date = to_date('31/12/'||w2_year,'dd/mm/yyyy')