APPS.PER_CPA_BUS dependencies on PER_BUSINESS_GROUPS

Line 27: -- per_cagr_api_parameters and PER_BUSINESS_GROUPS

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

Line 33: from per_business_groups pbg

29: -- the current business group context can be derived.
30: -- Remove this comment when the edit has been completed.
31: cursor csr_sec_grp is
32: select pbg.security_group_id
33: from per_business_groups pbg
34: , per_cagr_api_parameters cpa
35: where cpa.cagr_api_param_id = p_cagr_api_param_id;
36: --
37: -- Declare local variables

Line 91: -- per_cagr_api_parameters and PER_BUSINESS_GROUPS

87: --
88: -- Declare cursor
89: --
90: -- EDIT_HERE In the following cursor statement add join(s) between
91: -- per_cagr_api_parameters and PER_BUSINESS_GROUPS
92: -- so that the legislation_code for
93: -- the current business group context can be derived.
94: -- Remove this comment when the edit has been completed.
95: cursor csr_leg_code is

Line 97: from per_business_groups pbg

93: -- the current business group context can be derived.
94: -- Remove this comment when the edit has been completed.
95: cursor csr_leg_code is
96: select pbg.legislation_code
97: from per_business_groups pbg
98: , per_cagr_api_parameters cpa
99: where cpa.cagr_api_param_id = p_cagr_api_param_id;
100: --
101: -- Declare local variables