DBA Data[Home] [Help]

APPS.PER_CNF_BUS dependencies on PER_BUSINESS_GROUPS_PERF

Line 28: -- per_ri_configurations and PER_BUSINESS_GROUPS_PERF

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

Line 35: from per_business_groups_perf pbg

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

Line 105: -- per_ri_configurations and PER_BUSINESS_GROUPS_PERF

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

Line 111: from per_business_groups_perf pbg

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