APPS.HXC_HSD_BUS dependencies on HXC_SEEDDATA_BY_LEVEL

Line 32: -- hxc_seeddata_by_level and PER_BUSINESS_GROUPS_PERF

28: --
29: -- Declare cursor
30: --
31: -- EDIT_HERE In the following cursor statement add join(s) between
32: -- hxc_seeddata_by_level and PER_BUSINESS_GROUPS_PERF
33: -- so that the security_group_id for
34: -- the current business group context can be derived.
35: -- Remove this comment when the edit has been completed.
36: cursor csr_sec_grp is

Line 40: , hxc_seeddata_by_level hsd

36: cursor csr_sec_grp is
37: select pbg.security_group_id,
38: pbg.legislation_code
39: from per_business_groups_perf pbg
40: , hxc_seeddata_by_level hsd
41: -- , EDIT_HERE table_name(s) 333
42: where hsd.object_id = p_object_id
43: and hsd.object_type = p_object_type;
44: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;

Line 124: -- hxc_seeddata_by_level and PER_BUSINESS_GROUPS_PERF

120: --
121: -- Declare cursor
122: --
123: -- EDIT_HERE In the following cursor statement add join(s) between
124: -- hxc_seeddata_by_level and PER_BUSINESS_GROUPS_PERF
125: -- so that the legislation_code for
126: -- the current business group context can be derived.
127: -- Remove this comment when the edit has been completed.
128: cursor csr_leg_code is

Line 131: , hxc_seeddata_by_level hsd

127: -- Remove this comment when the edit has been completed.
128: cursor csr_leg_code is
129: select pbg.legislation_code
130: from per_business_groups_perf pbg
131: , hxc_seeddata_by_level hsd
132: -- , EDIT_HERE table_name(s) 333
133: where hsd.object_id = p_object_id
134: and hsd.object_type = p_object_type;
135: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;

Line 292: (p_hxc_required in hxc_seeddata_by_level.hxc_required%TYPE

288: -- ----------------------------------------------------------------------------
289:
290:
291: Procedure chk_hxc_required
292: (p_hxc_required in hxc_seeddata_by_level.hxc_required%TYPE
293: ) IS
294:
295: Cursor c_chk_required
296: IS

Line 359: (p_owner_application_id in hxc_seeddata_by_level.owner_application_id%TYPE)

355: -- {End Of Comments}
356: -- ----------------------------------------------------------------------------
357:
358: Procedure chk_application_id
359: (p_owner_application_id in hxc_seeddata_by_level.owner_application_id%TYPE)
360: IS
361:
362: Cursor c_chk_application is
363: select 'Y' from fnd_application

Line 427: (p_object_id in hxc_seeddata_by_level.object_id%TYPE

423: -- {End Of Comments}
424: -- ----------------------------------------------------------------------------
425:
426: Procedure chk_object
427: (p_object_id in hxc_seeddata_by_level.object_id%TYPE
428: ,p_object_type in hxc_seeddata_by_level.object_type%TYPE ) IS
429:
430: l_query varchar2(2000);
431:

Line 428: ,p_object_type in hxc_seeddata_by_level.object_type%TYPE ) IS

424: -- ----------------------------------------------------------------------------
425:
426: Procedure chk_object
427: (p_object_id in hxc_seeddata_by_level.object_id%TYPE
428: ,p_object_type in hxc_seeddata_by_level.object_type%TYPE ) IS
429:
430: l_query varchar2(2000);
431:
432: TYPE get_value IS REF CURSOR; -- define REF CURSOR type