APPS.FF_FCU_BUS dependencies on PER_BUSINESS_GROUPS_PERF

Line 31: -- ff_function_context_usages and PER_BUSINESS_GROUPS_PERF

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

Line 38: from per_business_groups_perf pbg

34: -- Remove this comment when the edit has been completed.
35: cursor csr_sec_grp is
36: select pbg.security_group_id,
37: pbg.legislation_code
38: from per_business_groups_perf pbg
39: , ff_functions fnc
40: where fnc.function_id = p_function_id
41: and pbg.business_group_id(+) = fnc.business_group_id;
42: --

Line 115: -- ff_function_context_usages and PER_BUSINESS_GROUPS_PERF

111: --
112: -- Declare cursor
113: --
114: -- EDIT_HERE In the following cursor statement add join(s) between
115: -- ff_function_context_usages and PER_BUSINESS_GROUPS_PERF
116: -- so that the legislation_code for
117: -- the current business group context can be derived.
118: -- Remove this comment when the edit has been completed.
119: cursor csr_leg_code is

Line 121: from per_business_groups_perf pbg

117: -- the current business group context can be derived.
118: -- Remove this comment when the edit has been completed.
119: cursor csr_leg_code is
120: select pbg.legislation_code
121: from per_business_groups_perf pbg
122: , ff_function_context_usages fcu
123: , ff_functions fff
124: where fcu.function_id = fff.function_id
125: and fcu.function_id = p_function_id