APPS.GHR_CST_BUS dependencies on PER_BUSINESS_GROUPS

Line 27: -- ghr_compl_agency_costs and PER_BUSINESS_GROUPS

23: --
24: -- Declare cursor
25: --
26: -- EDIT_HERE In the following cursor statement add join(s) between
27: -- ghr_compl_agency_costs 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: , ghr_compl_agency_costs cst
35: -- , EDIT_HERE table_name(s) 333
36: where cst.compl_agency_cost_id = p_compl_agency_cost_id;
37: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;

Line 93: -- ghr_compl_agency_costs and PER_BUSINESS_GROUPS

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

Line 99: from per_business_groups pbg

95: -- the current business group context can be derived.
96: -- Remove this comment when the edit has been completed.
97: cursor csr_leg_code is
98: select pbg.legislation_code
99: from per_business_groups pbg
100: , ghr_compl_agency_costs cst
101: -- , EDIT_HERE table_name(s) 333
102: where cst.compl_agency_cost_id = p_compl_agency_cost_id;
103: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;