APPS.HXC_HAN_BUS dependencies on PER_BUSINESS_GROUPS_PERF

Line 32: -- hxc_app_comp_notifications and PER_BUSINESS_GROUPS_PERF

28: --
29: -- Declare cursor
30: --
31: -- EDIT_HERE In the following cursor statement add join(s) between
32: -- hxc_app_comp_notifications 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 39: from per_business_groups_perf pbg

35: -- Remove this comment when the edit has been completed.
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_app_comp_notifications han
41: -- , EDIT_HERE table_name(s) 333
42: where han.comp_notification_id = p_comp_notification_id
43: and han.object_version_number = p_object_version_number;

Line 122: -- hxc_app_comp_notifications and PER_BUSINESS_GROUPS_PERF

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

Line 128: from per_business_groups_perf pbg

124: -- the current business group context can be derived.
125: -- Remove this comment when the edit has been completed.
126: cursor csr_leg_code is
127: select pbg.legislation_code
128: from per_business_groups_perf pbg
129: , hxc_app_comp_notifications han
130: -- , EDIT_HERE table_name(s) 333
131: where han.comp_notification_id = p_comp_notification_id
132: and han.object_version_number = p_object_version_number;