579: --
580: Cursor C_Sel1 is
581: select
582: null 583: from ame_calling_apps 584: where application_id = p_rec.application_id
585: and p_effective_date
586: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date)
587: for update nowait;