APPS.PAY_US_MMREF_REPORTING1 dependencies on FF_CONTEXTS

Line 302: FROM ff_contexts

298: /* cursor to get_context_of_tax_unit_id */
299: CURSOR c_context_tax_unit_id
300: IS
301: SELECT context_id
302: FROM ff_contexts
303: WHERE context_name = 'TAX_UNIT_ID';
304:
305: /* cursor to get context of jurisdiction */
306: CURSOR c_context_jurisdiction

Line 309: FROM ff_contexts

305: /* cursor to get context of jurisdiction */
306: CURSOR c_context_jurisdiction
307: IS
308: SELECT context_id
309: FROM ff_contexts
310: WHERE context_name = 'JURISDICTION_CODE';
311:
312: /* cursor to check if the state tax Rules have been added or Not. */
313: CURSOR c_chk_archive_state_code(cp_tax_unit_id number,cp_payroll_action_id number)

Line 318: ff_contexts fc3,

314: IS
315: SELECT 'Y'
316: FROM ff_archive_item_contexts con3,
317: ff_archive_item_contexts con2,
318: ff_contexts fc3,
319: ff_contexts fc2,
320: ff_archive_items target,
321: ff_database_items fdi
322: WHERE target.context1 = to_char(cp_payroll_action_id)

Line 319: ff_contexts fc2,

315: SELECT 'Y'
316: FROM ff_archive_item_contexts con3,
317: ff_archive_item_contexts con2,
318: ff_contexts fc3,
319: ff_contexts fc2,
320: ff_archive_items target,
321: ff_database_items fdi
322: WHERE target.context1 = to_char(cp_payroll_action_id)
323: /* context of payroll_action_id */

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

365: l_state_tax_rules_exist CHAR(1);
366: l_person_in_state CHAR(1);
367: l_user_entity_id number;
368: l_context_jursidiction number;
369: l_context_tax_unit_id number; --ff_contexts.context_id%type;
370: l_package_error_status char(1) := 'N';
371: l_ein number;
372: l_ein_result varchar2(30);
373: BEGIN

Line 1085: ff_contexts fc,

1081: p_tax_unit_id number) is
1082: select to_number(fai.value) value
1083: from ff_archive_item_contexts faic,
1084: ff_archive_items fai,
1085: ff_contexts fc,
1086: ff_database_items fdi
1087: where fdi.user_name = p_user_name
1088: and fc.context_name = 'TAX_UNIT_ID'
1089: and fai.context1 = to_char(p_assignment_action_id)

Line 1101: ff_contexts fc,

1097: p_tax_unit_id number) is
1098: select to_number(fai.value) value
1099: from ff_archive_item_contexts faic,
1100: ff_archive_items fai,
1101: ff_contexts fc,
1102: ff_database_items fdi
1103: where fdi.user_name IN ('A_REGULAR_EARNINGS_PER_GRE_YTD',
1104: 'A_SUPPLEMENTAL_EARNINGS_FOR_FIT_SUBJECT_TO_TAX_PER_GRE_YTD',
1105: 'A_SUPPLEMENTAL_EARNINGS_FOR_NWFIT_SUBJECT_TO_TAX_PER_GRE_YTD',

Line 1391: ff_contexts fc,

1387:
1388: SELECT value
1389: INTO l_ein_val
1390: FROM ff_archive_items fai,
1391: ff_contexts fc,
1392: ff_archive_item_contexts faic
1393: WHERE fai.context1 = to_char(p_pactid)
1394: AND user_entity_id = c_id.user_entity_id
1395: AND faic.archive_item_id = fai.archive_item_id

Line 1548: ff_contexts fc3,

1544: SELECT target.value
1545: FROM
1546: ff_archive_item_contexts con3,
1547: ff_archive_item_contexts con2,
1548: ff_contexts fc3,
1549: ff_contexts fc2,
1550: ff_archive_items target,
1551: ff_database_items fdi
1552: WHERE target.context1 = to_char(cp_payroll_action_id)

Line 1549: ff_contexts fc2,

1545: FROM
1546: ff_archive_item_contexts con3,
1547: ff_archive_item_contexts con2,
1548: ff_contexts fc3,
1549: ff_contexts fc2,
1550: ff_archive_items target,
1551: ff_database_items fdi
1552: WHERE target.context1 = to_char(cp_payroll_action_id)
1553: /* context of payroll_action_id */