APPS.HXC_LCK_BUS dependencies on PER_BUSINESS_GROUPS_PERF

Line 29: -- hxc_locker_types and PER_BUSINESS_GROUPS_PERF

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

Line 35: from per_business_groups_perf pbg

31: -- the current business group context can be derived.
32: -- Remove this comment when the edit has been completed.
33: cursor csr_sec_grp is
34: select distinct pbg.security_group_id
35: from per_business_groups_perf pbg
36: , hxc_locker_types lck
37: -- , EDIT_HERE table_name(s) 333
38: where lck.locker_type_id = p_locker_type_id;
39: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;

Line 104: -- hxc_locker_types and PER_BUSINESS_GROUPS_PERF

100: --
101: -- Declare cursor
102: --
103: -- EDIT_HERE In the following cursor statement add join(s) between
104: -- hxc_locker_types and PER_BUSINESS_GROUPS_PERF
105: -- so that the legislation_code for
106: -- the current business group context can be derived.
107: -- Remove this comment when the edit has been completed.
108: cursor csr_leg_code is

Line 110: from per_business_groups_perf pbg

106: -- the current business group context can be derived.
107: -- Remove this comment when the edit has been completed.
108: cursor csr_leg_code is
109: select pbg.legislation_code
110: from per_business_groups_perf pbg
111: , hxc_locker_types lck
112: -- , EDIT_HERE table_name(s) 333
113: where lck.locker_type_id = p_locker_type_id;
114: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;