[Home] [Help]
132: ) IS
133: --
134: cursor csr_application is
135: select 1
136: from ame_calling_apps
137: where application_id=p_application_id
138: and p_effective_date between start_date
139: and nvl(end_date - ame_util.oneSecond, p_effective_date);
140: l_proc varchar2(72) := g_package || 'CHK_APPLICATION_ID';