DBA Data[Home] [Help]

APPS.PAY_US_SQWL_ARCHIVE dependencies on FF_CONTEXTS

Line 1698: from ff_contexts

1694: l_arch_gre_step := 10;
1695:
1696: select context_id
1697: into l_tax_context_id
1698: from ff_contexts
1699: where context_name = 'TAX_UNIT_ID';
1700:
1701: /* Get the context_id for 'JURISDICTION_CODE' */
1702:

Line 1707: from ff_contexts

1703: l_arch_gre_step := 20;
1704:
1705: select context_id
1706: into l_jursd_context_id
1707: from ff_contexts
1708: where context_name = 'JURISDICTION_CODE';
1709:
1710:
1711: /* get the state code for the state abbrev */

Line 2130: FROM ff_contexts

2126: l_quarter_end := ADD_MONTHS(TRUNC(p_effective_date, 'Q'),3) - 1;
2127:
2128: SELECT context_id
2129: INTO l_context_id_assignment_id
2130: FROM ff_contexts
2131: WHERE context_name = 'ASSIGNMENT_ID';
2132:
2133: /* l_user_entity_id, l_context_id_date_earned, l_context_id_assignment_id,
2134: can be declared as global variables, then there will be no need