APPS.PAY_US_ARCHIVE dependencies on FF_CONTEXTS

Line 1861: from ff_contexts

1857:
1858: l_archive_type := 'PA';
1859: select context_id
1860: into l_tax_context_id
1861: from ff_contexts
1862: where context_name = 'TAX_UNIT_ID';
1863:
1864: l_step := 2;
1865:

Line 1868: from ff_contexts

1864: l_step := 2;
1865:
1866: select context_id
1867: into l_jursd_context_id
1868: from ff_contexts
1869: where context_name = 'JURISDICTION_CODE';
1870:
1871: l_step := 3;
1872: for i in p_sequence.first .. p_sequence.last

Line 2230: from ff_contexts

2226: l_arch_gre_step := 10;
2227: /* Get the context_id for 'TAX_UNIT_ID' */
2228: select context_id
2229: into l_tax_context_id
2230: from ff_contexts
2231: where context_name = 'TAX_UNIT_ID';
2232:
2233: l_arch_gre_step := 20;
2234: /* Get the context_id for 'JURISDICTION_CODE' */

Line 2238: from ff_contexts

2234: /* Get the context_id for 'JURISDICTION_CODE' */
2235:
2236: select context_id
2237: into l_jursd_context_id
2238: from ff_contexts
2239: where context_name = 'JURISDICTION_CODE';
2240:
2241: l_arch_gre_step := 30;
2242:

Line 3313: from ff_contexts

3309: l_step := 13;
3310:
3311: select context_id
3312: into g_jursd_context_id
3313: from ff_contexts
3314: where context_name = 'JURISDICTION_CODE';
3315:
3316: select context_id
3317: into g_tax_unit_context_id

Line 3318: from ff_contexts

3314: where context_name = 'JURISDICTION_CODE';
3315:
3316: select context_id
3317: into g_tax_unit_context_id
3318: from ff_contexts
3319: where context_name = 'TAX_UNIT_ID';
3320:
3321: /* get the user_entity_id of the dbis A_STATE_ABBREV, A_COUNTY_NAME,
3322: A_CITY_NAME, A_COUNTY_SD_NAME and A_CITY_SD_NAME */

Line 3570: l_jursd_context_id ff_contexts.context_id%type;

3566: l_step number := 0;
3567: l_county_code varchar2(3);
3568: l_city_code varchar2(4);
3569: l_person_id per_people_f.person_id%type;
3570: l_jursd_context_id ff_contexts.context_id%type;
3571: l_user_entity_id_tab pay_us_archive.number_data_type_table;
3572: l_user_entity_tab pay_us_archive.char240_data_type_table;
3573: l_defined_balance_id_tab pay_us_archive.number_data_type_table;
3574: l_value_tab pay_us_archive.char240_data_type_table;

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

4015: pay_archive.g_context_values.value(l_count) := l_taxunitid;
4016:
4017: hr_utility.trace('Initialised Pl/SQL table');
4018:
4019: /* Get the context_id for 'Jurisdiction' from ff_contexts */
4020:
4021: l_step := 8;
4022: /*
4023: select context_id

Line 4025: from ff_contexts

4021: l_step := 8;
4022: /*
4023: select context_id
4024: into l_jursd_context_id
4025: from ff_contexts
4026: where context_name = 'JURISDICTION_CODE';
4027:
4028: select context_id
4029: into l_tax_unit_context_id

Line 4030: from ff_contexts

4026: where context_name = 'JURISDICTION_CODE';
4027:
4028: select context_id
4029: into l_tax_unit_context_id
4030: from ff_contexts
4031: where context_name = 'TAX_UNIT_ID';
4032: */
4033:
4034: /* get the user_entity_id of the dbis A_STATE_ABBREV, A_COUNTY_NAME,