186: --
187: cursor C_Sel1 is
188: select apgc.application_id
189: from ame_approval_group_config apgc 190: ,ame_calling_apps aca 191: where approval_group_id = p_approval_group_id
192: and aca.application_id = apgc.application_id
193: and sysdate between apgc.start_date and
194: nvl(apgc.end_date-ame_util.oneSecond,SYSDATE)