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_CONTEXTS

Line 404: FROM ff_contexts

400: /* cursor to get_context_of_tax_unit_id */
401: CURSOR c_context_tax_unit_id
402: IS
403: SELECT context_id
404: FROM ff_contexts
405: WHERE context_name = 'TAX_UNIT_ID';
406:
407: /* cursor to get context of jurisdiction */
408: CURSOR c_context_jurisdiction

Line 411: FROM ff_contexts

407: /* cursor to get context of jurisdiction */
408: CURSOR c_context_jurisdiction
409: IS
410: SELECT context_id
411: FROM ff_contexts
412: WHERE context_name = 'JURISDICTION_CODE';
413:
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)

Line 420: ff_contexts fc3,

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
424: WHERE target.context1 = to_char(cp_payroll_action_id)

Line 421: ff_contexts fc2,

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
424: WHERE target.context1 = to_char(cp_payroll_action_id)
425: /* context of payroll_action_id */

Line 471: l_context_tax_unit_id number; --ff_contexts.context_id%type;

467: l_state_tax_rules_exist CHAR(1);
468: l_person_in_state CHAR(1);
469: l_user_entity_id number;
470: l_context_jursidiction number;
471: l_context_tax_unit_id number; --ff_contexts.context_id%type;
472: l_package_error_status char(1) := 'N';
473: l_ein number;
474: l_ein_result varchar2(30);
475: BEGIN

Line 982: 'from ff_contexts fc1, '||

978: 'paa.tax_unit_id, '||
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'' '||

Line 1050: 'from ff_contexts fc1, '||

1046: 'paa.tax_unit_id, '||
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'' '||

Line 1359: from ff_contexts fc1,

1355: paa.tax_unit_id,
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'

Line 1436: from ff_contexts fc1,

1432: paa.tax_unit_id,
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'

Line 1499: ff_contexts fc,

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'
1503: and fai.context1 = to_char(p_assignment_action_id)

Line 1515: ff_contexts fc,

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',
1519: 'A_SUPPLEMENTAL_EARNINGS_FOR_NWFIT_SUBJECT_TO_TAX_PER_GRE_YTD',

Line 1879: ff_contexts fc,

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

Line 2036: ff_contexts fc3,

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
2040: WHERE target.context1 = to_char(cp_payroll_action_id)

Line 2037: ff_contexts fc2,

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
2040: WHERE target.context1 = to_char(cp_payroll_action_id)
2041: /* context of payroll_action_id */