APPS.PAY_US_ARCHIVE dependencies on FF_CONTEXTS

Line 1557: from ff_contexts

1553:
1554: l_archive_type := 'PA';
1555: select context_id
1556: into l_tax_context_id
1557: from ff_contexts
1558: where context_name = 'TAX_UNIT_ID';
1559:
1560: l_step := 2;
1561:

Line 1564: from ff_contexts

1560: l_step := 2;
1561:
1562: select context_id
1563: into l_jursd_context_id
1564: from ff_contexts
1565: where context_name = 'JURISDICTION_CODE';
1566:
1567: l_step := 3;
1568: for i in p_sequence.first .. p_sequence.last

Line 1905: from ff_contexts

1901: l_arch_gre_step := 10;
1902: /* Get the context_id for 'TAX_UNIT_ID' */
1903: select context_id
1904: into l_tax_context_id
1905: from ff_contexts
1906: where context_name = 'TAX_UNIT_ID';
1907:
1908: l_arch_gre_step := 20;
1909: /* Get the context_id for 'JURISDICTION_CODE' */

Line 1913: from ff_contexts

1909: /* Get the context_id for 'JURISDICTION_CODE' */
1910:
1911: select context_id
1912: into l_jursd_context_id
1913: from ff_contexts
1914: where context_name = 'JURISDICTION_CODE';
1915:
1916: l_arch_gre_step := 30;
1917:

Line 2796: from ff_contexts

2792: l_step := 13;
2793:
2794: select context_id
2795: into g_jursd_context_id
2796: from ff_contexts
2797: where context_name = 'JURISDICTION_CODE';
2798:
2799: select context_id
2800: into g_tax_unit_context_id

Line 2801: from ff_contexts

2797: where context_name = 'JURISDICTION_CODE';
2798:
2799: select context_id
2800: into g_tax_unit_context_id
2801: from ff_contexts
2802: where context_name = 'TAX_UNIT_ID';
2803:
2804: /* get the user_entity_id of the dbis A_STATE_ABBREV, A_COUNTY_NAME,
2805: A_CITY_NAME, A_COUNTY_SD_NAME and A_CITY_SD_NAME */

Line 2998: l_jursd_context_id ff_contexts.context_id%type;

2994: l_step number := 0;
2995: l_county_code varchar2(3);
2996: l_city_code varchar2(4);
2997: l_person_id per_people_f.person_id%type;
2998: l_jursd_context_id ff_contexts.context_id%type;
2999: l_user_entity_id_tab pay_us_archive.number_data_type_table;
3000: l_user_entity_tab pay_us_archive.char240_data_type_table;
3001: l_defined_balance_id_tab pay_us_archive.number_data_type_table;
3002: l_value_tab pay_us_archive.char240_data_type_table;

Line 3387: /* Get the context_id for 'Jurisdiction' from ff_contexts */

3383: pay_archive.g_context_values.value(l_count) := l_taxunitid;
3384:
3385: hr_utility.trace('Initialised Pl/SQL table');
3386:
3387: /* Get the context_id for 'Jurisdiction' from ff_contexts */
3388:
3389: l_step := 8;
3390: /*
3391: select context_id

Line 3393: from ff_contexts

3389: l_step := 8;
3390: /*
3391: select context_id
3392: into l_jursd_context_id
3393: from ff_contexts
3394: where context_name = 'JURISDICTION_CODE';
3395:
3396: select context_id
3397: into l_tax_unit_context_id

Line 3398: from ff_contexts

3394: where context_name = 'JURISDICTION_CODE';
3395:
3396: select context_id
3397: into l_tax_unit_context_id
3398: from ff_contexts
3399: where context_name = 'TAX_UNIT_ID';
3400: */
3401:
3402: /* get the user_entity_id of the dbis A_STATE_ABBREV, A_COUNTY_NAME,