APPS.PAY_CA_T4AEOY_ARCHIVE dependencies on FF_CONTEXTS

Line 1408: from ff_contexts

1404: end;
1405:
1406: select context_id
1407: into l_taxunit_context_id
1408: from ff_contexts
1409: where context_name = 'TAX_UNIT_ID';
1410:
1411: l_counter := 0;
1412: l_arch_gre_step := 40;

Line 1735: l_jursd_context_id ff_contexts.context_id%type;

1731: l_cty_sd_name pay_us_city_school_dsts.school_dst_name%type;
1732: l_step number := 0;
1733: l_county_code varchar2(3);
1734: l_city_code varchar2(4);
1735: l_jursd_context_id ff_contexts.context_id%type;
1736: l_taxunit_context_id ff_contexts.context_id%type;
1737: l_seq_tab pay_ca_t4aeoy_archive.number_data_type_table;
1738: l_context_id_tab pay_ca_t4aeoy_archive.number_data_type_table;
1739: l_context_val_tab pay_ca_t4aeoy_archive.char240_data_type_table;

Line 1736: l_taxunit_context_id ff_contexts.context_id%type;

1732: l_step number := 0;
1733: l_county_code varchar2(3);
1734: l_city_code varchar2(4);
1735: l_jursd_context_id ff_contexts.context_id%type;
1736: l_taxunit_context_id ff_contexts.context_id%type;
1737: l_seq_tab pay_ca_t4aeoy_archive.number_data_type_table;
1738: l_context_id_tab pay_ca_t4aeoy_archive.number_data_type_table;
1739: l_context_val_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1740: l_chunk number;

Line 1940: from pay_action_contexts pac,ff_contexts ffc

1936: between to_char(all_paf.effective_start_date,'YYYY')
1937: and to_char(all_paf.effective_end_date,'YYYY')
1938: and run_paa.assignment_id = all_paf.assignment_id
1939: and exists (select 1
1940: from pay_action_contexts pac,ff_contexts ffc
1941: where ffc.context_name = 'JURISDICTION_CODE'
1942: and pac.context_id = ffc.context_id
1943: and pac.assignment_id = run_paa.assignment_id);
1944: