192: --
193: cursor C_Sel1 is
194: select apgc.application_id
195: from ame_approval_group_config apgc 196: ,ame_calling_apps aca 197: where approval_group_id = p_approval_group_id
198: and aca.application_id = apgc.application_id
199: and sysdate between apgc.start_date and
200: nvl(apgc.end_date-ame_util.oneSecond,SYSDATE)