APPS.PAY_CA_EOY_ARCHIVE dependencies on FF_CONTEXTS

Line 1044: ff_contexts fc

1040: SELECT fai1.context1,fdi1.user_entity_id,fai1.value
1041: FROM FF_ARCHIVE_ITEMS FAI1,
1042: ff_database_items fdi1,
1043: ff_archive_item_contexts faic,
1044: ff_contexts fc
1045: WHERE FAI1.USER_ENTITY_ID = fdi1.user_entity_id
1046: and fai1.archive_item_id = faic.archive_item_id
1047: and fc.context_id = faic.context_id
1048: and fc.context_name = 'JURISDICTION_CODE'

Line 1603: from ff_contexts

1599: end;
1600:
1601: select context_id
1602: into l_taxunit_context_id
1603: from ff_contexts
1604: where context_name = 'TAX_UNIT_ID';
1605:
1606: l_counter := 0;
1607: l_arch_gre_step := 40;

Line 1924: l_jursd_context_id ff_contexts.context_id%type;

1920: l_cty_sd_name pay_us_city_school_dsts.school_dst_name%type;
1921: l_step number := 0;
1922: l_county_code varchar2(3);
1923: l_city_code varchar2(4);
1924: l_jursd_context_id ff_contexts.context_id%type;
1925: l_taxunit_context_id ff_contexts.context_id%type;
1926: l_seq_tab pay_ca_eoy_archive.number_data_type_table;
1927: l_context_id_tab pay_ca_eoy_archive.number_data_type_table;
1928: l_context_val_tab pay_ca_eoy_archive.char240_data_type_table;

Line 1925: l_taxunit_context_id ff_contexts.context_id%type;

1921: l_step number := 0;
1922: l_county_code varchar2(3);
1923: l_city_code varchar2(4);
1924: l_jursd_context_id ff_contexts.context_id%type;
1925: l_taxunit_context_id ff_contexts.context_id%type;
1926: l_seq_tab pay_ca_eoy_archive.number_data_type_table;
1927: l_context_id_tab pay_ca_eoy_archive.number_data_type_table;
1928: l_context_val_tab pay_ca_eoy_archive.char240_data_type_table;
1929: l_chunk number;

Line 2185: ff_contexts fc

2181: pay_assignment_actions paa,
2182: pay_payroll_actions ppa,
2183: pay_action_classifications pac,
2184: pay_action_contexts pac1,
2185: ff_contexts fc
2186: where paf.person_id = p_person_id
2187: and paa.assignment_id = paf.assignment_id
2188: and paa.tax_unit_id = l_tax_unit_id
2189: and paa.payroll_action_id = ppa.payroll_action_id

Line 2222: ff_contexts fc

2218: per_all_people_f ppf,
2219: pay_payroll_actions ppa,
2220: pay_action_classifications pac,
2221: pay_action_contexts pac1,
2222: ff_contexts fc
2223: where ppf.person_id = cp_person_id
2224: and paf.person_id = ppf.person_id
2225: and paf.assignment_id = paa.assignment_id
2226: and paa.tax_unit_id = cp_tax_unit_id