APPS.PAY_US_MMREF_LOCAL dependencies on FF_CONTEXTS

Line 345: FROM ff_contexts

341: /* cursor to get_context_of_tax_unit_id */
342: CURSOR c_context_tax_unit_id
343: IS
344: SELECT context_id
345: FROM ff_contexts
346: WHERE context_name = 'TAX_UNIT_ID';
347:
348: /* cursor to get context of jurisdiction */
349: CURSOR c_context_jurisdiction

Line 352: FROM ff_contexts

348: /* cursor to get context of jurisdiction */
349: CURSOR c_context_jurisdiction
350: IS
351: SELECT context_id
352: FROM ff_contexts
353: WHERE context_name = 'JURISDICTION_CODE';
354:
355: /* cursor to check if the state tax Rules have been added or Not. */
356: CURSOR c_chk_archive_state_code(cp_tax_unit_id number,cp_payroll_action_id number)

Line 361: ff_contexts fc3,

357: IS
358: SELECT 'Y'
359: FROM ff_archive_item_contexts con3,
360: ff_archive_item_contexts con2,
361: ff_contexts fc3,
362: ff_contexts fc2,
363: ff_archive_items target,
364: ff_database_items fdi
365: WHERE target.context1 = to_char(cp_payroll_action_id)

Line 362: ff_contexts fc2,

358: SELECT 'Y'
359: FROM ff_archive_item_contexts con3,
360: ff_archive_item_contexts con2,
361: ff_contexts fc3,
362: ff_contexts fc2,
363: ff_archive_items target,
364: ff_database_items fdi
365: WHERE target.context1 = to_char(cp_payroll_action_id)
366: /* context of payroll_action_id */

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

415: l_state_tax_rules_exist CHAR(1);
416: l_person_in_state CHAR(1);
417: l_user_entity_id number;
418: l_context_jursidiction number;
419: l_context_tax_unit_id number; --ff_contexts.context_id%type;
420: l_package_error_status char(1) := 'N';
421: l_ein number;
422: l_ein_result varchar2(30);
423: BEGIN

Line 995: ff_contexts fc1 , --for city context

991: pay_assignment_actions paa, /* YREND PAA */
992: pay_payroll_actions ppa, /* YREND PPA */
993: per_all_assignments_f paf,
994: pay_payroll_actions ppa1,
995: ff_contexts fc1 , --for city context
996: ff_archive_items fai1, -- city
997: ff_archive_item_contexts faic1, -- city_context
998: ff_database_items fdi1 --database_items for City_withheld
999: --,pay_us_city_tax_info_f puctif

Line 1080: ff_contexts fc,

1076: p_tax_unit_id number) is
1077: select to_number(fai.value)
1078: from ff_archive_item_contexts faic,
1079: ff_archive_items fai,
1080: ff_contexts fc,
1081: ff_database_items fdi
1082: where fdi.user_name = 'A_GROSS_EARNINGS_PER_GRE_YTD'
1083: and fc.context_name = 'TAX_UNIT_ID'
1084: and fai.context1 = to_char(p_assignment_action_id)

Line 1297: ff_contexts fc,

1293:
1294: SELECT value
1295: INTO l_ein_val
1296: FROM ff_archive_items fai,
1297: ff_contexts fc,
1298: ff_archive_item_contexts faic
1299: WHERE fai.context1 = to_char(p_pactid)
1300: AND user_entity_id = c_id.user_entity_id
1301: AND faic.archive_item_id = fai.archive_item_id

Line 1448: ff_contexts fc3,

1444: SELECT target.value
1445: FROM
1446: ff_archive_item_contexts con3,
1447: ff_archive_item_contexts con2,
1448: ff_contexts fc3,
1449: ff_contexts fc2,
1450: ff_archive_items target,
1451: ff_database_items fdi
1452: WHERE target.context1 = to_char(cp_payroll_action_id)

Line 1449: ff_contexts fc2,

1445: FROM
1446: ff_archive_item_contexts con3,
1447: ff_archive_item_contexts con2,
1448: ff_contexts fc3,
1449: ff_contexts fc2,
1450: ff_archive_items target,
1451: ff_database_items fdi
1452: WHERE target.context1 = to_char(cp_payroll_action_id)
1453: /* context of payroll_action_id */