APPS.PAY_US_MAGW2_REPORTING dependencies on FF_CONTEXTS

Line 333: FROM ff_contexts

329:
330: CURSOR c_context_tax_unit_id
331: IS
332: SELECT context_id
333: FROM ff_contexts
334: WHERE context_name = 'TAX_UNIT_ID';
335:
336:
337: /* cursor to get context of jurisdiction */

Line 342: FROM ff_contexts

338:
339: CURSOR c_context_jurisdiction
340: IS
341: SELECT context_id
342: FROM ff_contexts
343: WHERE context_name = 'JURISDICTION_CODE';
344:
345:
346: /* cursor to determine if archive gre has any person in State */

Line 388: ff_contexts fc3,

384: SELECT 'Y'
385: FROM
386: ff_archive_item_contexts con3,
387: ff_archive_item_contexts con2,
388: ff_contexts fc3,
389: ff_contexts fc2,
390: ff_archive_items target,
391: ff_database_items fdi
392: WHERE target.context1 = cp_payroll_action_id

Line 389: ff_contexts fc2,

385: FROM
386: ff_archive_item_contexts con3,
387: ff_archive_item_contexts con2,
388: ff_contexts fc3,
389: ff_contexts fc2,
390: ff_archive_items target,
391: ff_database_items fdi
392: WHERE target.context1 = cp_payroll_action_id
393: /* context of payroll_action_id */

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

434: l_state_tax_rules_exist CHAR(1);
435: l_person_in_state CHAR(1);
436: l_user_entity_id number;
437: l_context_jursidiction number;
438: l_context_tax_unit_id number; --ff_contexts.context_id%type;
439: l_package_error_status char(1) := 'N';
440: BEGIN
441: /* GET the context and user entity id */
442:

Line 1006: ff_contexts fc,

1002: p_tax_unit_id number) is
1003: select to_number(fai.value)
1004: from ff_archive_item_contexts faic,
1005: ff_archive_items fai,
1006: ff_contexts fc,
1007: ff_database_items fdi
1008: where fdi.user_name = 'A_GROSS_EARNINGS_PER_GRE_YTD'
1009: and fc.context_name = 'TAX_UNIT_ID'
1010: and fai.context1 = p_assignment_action_id