DBA Data[Home] [Help]

APPS.PAY_CA_T4AEOY_ARCHIVE dependencies on FF_CONTEXTS

Line 1607: from ff_contexts

1603: end;
1604:
1605: select context_id
1606: into l_taxunit_context_id
1607: from ff_contexts
1608: where context_name = 'TAX_UNIT_ID';
1609:
1610: l_counter := 0;
1611: l_arch_gre_step := 40;

Line 2071: from pay_action_contexts pac,ff_contexts ffc

2067: between to_char(all_paf.effective_start_date,'YYYY')
2068: and to_char(all_paf.effective_end_date,'YYYY')
2069: and run_paa.assignment_id = all_paf.assignment_id
2070: and exists (select 1
2071: from pay_action_contexts pac,ff_contexts ffc
2072: where ffc.context_name = 'JURISDICTION_CODE'
2073: and pac.context_id = ffc.context_id
2074: and pac.assignment_id = run_paa.assignment_id);
2075:

Line 3275: l_jursd_context_id ff_contexts.context_id%type;

3271: l_cty_sd_name pay_us_city_school_dsts.school_dst_name%type;
3272: l_step number := 0;
3273: l_county_code varchar2(3);
3274: l_city_code varchar2(4);
3275: l_jursd_context_id ff_contexts.context_id%type;
3276: l_taxunit_context_id ff_contexts.context_id%type;
3277: l_seq_tab pay_ca_t4aeoy_archive.number_data_type_table;
3278: l_context_id_tab pay_ca_t4aeoy_archive.number_data_type_table;
3279: l_context_val_tab pay_ca_t4aeoy_archive.char240_data_type_table;

Line 3276: l_taxunit_context_id ff_contexts.context_id%type;

3272: l_step number := 0;
3273: l_county_code varchar2(3);
3274: l_city_code varchar2(4);
3275: l_jursd_context_id ff_contexts.context_id%type;
3276: l_taxunit_context_id ff_contexts.context_id%type;
3277: l_seq_tab pay_ca_t4aeoy_archive.number_data_type_table;
3278: l_context_id_tab pay_ca_t4aeoy_archive.number_data_type_table;
3279: l_context_val_tab pay_ca_t4aeoy_archive.char240_data_type_table;
3280: l_chunk number;

Line 3485: from pay_action_contexts pac,ff_contexts ffc

3481: between to_char(all_paf.effective_start_date,'YYYY')
3482: and to_char(all_paf.effective_end_date,'YYYY')
3483: and run_paa.assignment_id = all_paf.assignment_id
3484: and exists (select 1
3485: from pay_action_contexts pac,ff_contexts ffc
3486: where ffc.context_name = 'JURISDICTION_CODE'
3487: and pac.context_id = ffc.context_id
3488: and pac.assignment_id = run_paa.assignment_id);
3489: