APPS.AME_ITU_BUS dependencies on AME_CALLING_APPS

Line 16: -- ame_calling_apps table and must be valid over the given date ranges

12: -- {Start Of Comments}
13: --
14: -- Description:
15: -- This procedure ensure that application_id must be already defined in
16: -- ame_calling_apps table and must be valid over the given date ranges
17: --
18: -- Pre-Requisites:
19: -- None
20: --

Line 30: -- ame_calling_apps table

26: -- Processing continues if a valid application_id has been entered.
27: --
28: -- Post Failure:
29: -- An application error is raised if the application_id is not defined in
30: -- ame_calling_apps table
31: --
32: -- Access Status:
33: -- Internal Row Handler Use Only.
34: --

Line 43: from ame_calling_apps

39: ) IS
40: --
41: cursor csr_application_id is
42: select null
43: from ame_calling_apps
44: where application_id = p_application_id
45: and p_effective_date between start_date
46: and nvl(end_date - ame_util.oneSecond, p_effective_date);
47: l_proc varchar2(72) := g_package || 'CHK_APPLICATION_ID';