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 418: FROM ff_archive_item_contexts con3,

414: /* cursor to check if the state tax Rules have been added or Not. */
415: CURSOR c_chk_archive_state_code(cp_tax_unit_id number,cp_payroll_action_id number)
416: IS
417: SELECT 'Y'
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,

Line 419: ff_archive_item_contexts con2,

415: CURSOR c_chk_archive_state_code(cp_tax_unit_id number,cp_payroll_action_id number)
416: IS
417: SELECT 'Y'
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

Line 952: 'FROM ff_archive_item_contexts faic, '||

948: 30);
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, '||

Line 984: 'ff_archive_item_contexts faic1, '||

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 '||
988: 'and fdi1.user_name = ''A_COUNTY_WITHHELD_PER_JD_GRE_YTD'' '||

Line 1020: 'FROM ff_archive_item_contexts faic, '||

1016: 40);
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, '||

Line 1052: 'ff_archive_item_contexts faic1, '||

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 '||
1056: 'and fdi1.user_name = ''A_SCHOOL_WITHHELD_PER_JD_GRE_YTD'' '||

Line 1090: FROM ff_archive_item_contexts faic,

1086: ELSIF p_report_type = 'STW2' THEN
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,

Line 1178: FROM ff_archive_item_contexts faic,

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,
1179: ff_archive_items fai,
1180: ff_database_items fdi,
1181: pay_assignment_actions paa,
1182: pay_payroll_actions ppa,

Line 1250: FROM ff_archive_item_contexts faic,

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,
1251: ff_archive_items fai,
1252: ff_database_items fdi,
1253: pay_assignment_actions paa,
1254: pay_payroll_actions ppa,

Line 1321: FROM ff_archive_item_contexts faic,

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,
1322: ff_archive_items fai,
1323: ff_database_items fdi,
1324: pay_assignment_actions paa,
1325: pay_payroll_actions ppa,

Line 1361: ff_archive_item_contexts faic1,

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
1365: and fdi1.user_name = 'A_COUNTY_WITHHELD_PER_JD_GRE_YTD'

Line 1399: FROM ff_archive_item_contexts faic,

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,
1400: ff_archive_items fai,
1401: ff_database_items fdi,
1402: pay_assignment_actions paa,
1403: pay_payroll_actions ppa,

Line 1438: ff_archive_item_contexts faic1,

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
1442: and fdi1.user_name = 'A_SCHOOL_WITHHELD_PER_JD_GRE_YTD'

Line 1497: from ff_archive_item_contexts faic,

1493: cursor csr_get_fed_wages(p_user_name varchar2,
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

Line 1513: from ff_archive_item_contexts faic,

1509:
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',

Line 1880: ff_archive_item_contexts faic

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
1883: AND faic.archive_item_id = fai.archive_item_id
1884: AND faic.context = to_char(l_gre)

Line 1929: ff_archive_item_contexts faic,

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
1933: AND faic.archive_item_id = fai.archive_item_id

Line 1930: ff_archive_item_contexts faic1

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
1933: AND faic.archive_item_id = fai.archive_item_id
1934: AND faic1.archive_item_id = fai.archive_item_id

Line 2034: ff_archive_item_contexts con3,

2030: cp_state_Code varchar2 )
2031: IS
2032: SELECT target.value
2033: FROM
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,

Line 2035: ff_archive_item_contexts con2,

2031: IS
2032: SELECT target.value
2033: FROM
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

Line 2607: FROM ff_archive_item_contexts faic

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

Line 2640: FROM ff_archive_item_contexts faic

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