APPS.OTA_COI_BUS dependencies on PER_BUSINESS_GROUPS_PERF

Line 34: -- ota_chat_obj_inclusions and PER_BUSINESS_GROUPS_PERF

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

Line 41: from per_business_groups_perf pbg

37: -- Remove this comment when the edit has been completed.
38: cursor csr_sec_grp is
39: select pbg.security_group_id,
40: pbg.legislation_code
41: from per_business_groups_perf pbg
42: , ota_chat_obj_inclusions coi
43: -- , EDIT_HERE table_name(s) 333
44: where coi.chat_id = p_chat_id
45: and coi.object_id = p_object_id

Line 129: -- ota_chat_obj_inclusions and PER_BUSINESS_GROUPS_PERF

125: --
126: -- Declare cursor
127: --
128: -- EDIT_HERE In the following cursor statement add join(s) between
129: -- ota_chat_obj_inclusions and PER_BUSINESS_GROUPS_PERF
130: -- so that the legislation_code for
131: -- the current business group context can be derived.
132: -- Remove this comment when the edit has been completed.
133: cursor csr_leg_code is

Line 135: from per_business_groups_perf pbg

131: -- the current business group context can be derived.
132: -- Remove this comment when the edit has been completed.
133: cursor csr_leg_code is
134: select pbg.legislation_code
135: from per_business_groups_perf pbg
136: , ota_chat_obj_inclusions coi
137: -- , EDIT_HERE table_name(s) 333
138: where coi.chat_id = p_chat_id
139: and coi.object_id = p_object_id