APPS.AME_AYL_BUS dependencies on PER_BUSINESS_GROUPS_PERF

Line 29: -- ame_action_types_tl and PER_BUSINESS_GROUPS_PERF

25: --
26: -- Declare cursor
27: --
28: -- EDIT_HERE In the following cursor statement add join(s) between
29: -- ame_action_types_tl 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 36: from per_business_groups_perf pbg

32: -- Remove this comment when the edit has been completed.
33: cursor csr_sec_grp is
34: select pbg.security_group_id,
35: pbg.legislation_code
36: from per_business_groups_perf pbg
37: , ame_action_types_tl ayl
38: -- , EDIT_HERE table_name(s) 333
39: where ayl.action_type_id = p_action_type_id;
40: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;

Line 108: -- ame_action_types_tl and PER_BUSINESS_GROUPS_PERF

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

Line 114: from per_business_groups_perf pbg

110: -- the current business group context can be derived.
111: -- Remove this comment when the edit has been completed.
112: cursor csr_leg_code is
113: select pbg.legislation_code
114: from per_business_groups_perf pbg
115: , ame_action_types_tl ayl
116: -- , EDIT_HERE table_name(s) 333
117: where ayl.action_type_id = p_action_type_id
118: and ayl.language = p_language;