APPS.PAY_MX_YREND_ARCH dependencies on FF_ARCHIVE_ITEMS

Line 530: FROM ff_archive_items fai

526: begin
527: hr_utility.set_location(gv_package || lv_procedure_name, 85);
528: SELECT fai.value
529: INTO ln_prev_isr_whld_value
530: FROM ff_archive_items fai
531: WHERE fai.context1 = gn_prev_asg_act_id
532: AND fai.user_entity_id = ln_arch_user_entity_id;
533: hr_utility.set_location(gv_package || lv_procedure_name, 87);
534: exception

Line 546: from ff_archive_items fai,

542: END IF;
543:
544: select count(*)
545: into ln_arc_item
546: from ff_archive_items fai,
547: ff_archive_item_contexts faic
548: where fai.archive_item_id = faic.archive_item_id
549: and fai.user_entity_id = ln_arch_user_entity_id
550: and fai.context1 = p_archive_action_id