APPS.PAY_MX_YREND_ARCH dependencies on FF_ARCHIVE_ITEMS

Line 603: FROM ff_archive_items fai

599: begin
600: hr_utility.set_location(gv_package || lv_procedure_name, 30);
601: SELECT fai.value
602: INTO ln_prev_isr_whld_value
603: FROM ff_archive_items fai
604: WHERE fai.context1 = gn_prev_asg_act_id
605: AND fai.user_entity_id = ln_arch_user_entity_id;
606: hr_utility.set_location(gv_package || lv_procedure_name, 40);
607: exception

Line 619: from ff_archive_items fai,

615: END IF;
616: hr_utility.set_location(gv_package || lv_procedure_name, 50);
617: select count(1)
618: into ln_arc_item
619: from ff_archive_items fai,
620: ff_archive_item_contexts faic
621: where fai.archive_item_id = faic.archive_item_id
622: and fai.user_entity_id = ln_arch_user_entity_id
623: and fai.context1 = p_archive_action_id

Line 664: FROM ff_user_entities ffu, ff_archive_items ffa

660: --
661: CURSOR c_get_arch_val(cp_archive_item_name VARCHAR2)
662: IS
663: SELECT ffa.archive_item_id, ffa.value
664: FROM ff_user_entities ffu, ff_archive_items ffa
665: WHERE ffu.user_entity_name = cp_archive_item_name
666: AND ffu.creator_type = 'X'
667: AND ffu.creator_id = 0
668: AND ffu.legislation_code = 'MX'

Line 1944: FROM ff_archive_items

1940: AND fnd_date.canonical_to_date(g_fiscal_year || '/12/31');
1941: /* Bug 13093752 */
1942: CURSOR c_get_amends_amount IS
1943: SELECT nvl(fnd_number.canonical_to_number(value),0)
1944: FROM ff_archive_items
1945: WHERE user_entity_id = (SELECT user_entity_id
1946: FROM ff_user_entities
1947: WHERE user_entity_name = 'A_AMENDS_PER_PDS_GRE_YTD')
1948: AND context1 = p_archive_action_id;