APPS.HXC_RTR_BUS dependencies on PER_BUSINESS_GROUPS

Line 29: -- hxc_retrieval_rules and PER_BUSINESS_GROUPS

25: --
26: -- Declare cursor
27: --
28: -- EDIT_HERE In the following cursor statement add join(s) between
29: -- hxc_retrieval_rules and PER_BUSINESS_GROUPS
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 35: from per_business_groups pbg

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
34: select pbg.security_group_id
35: from per_business_groups pbg
36: , hxc_retrieval_rules rtr
37: -- , EDIT_HERE table_name(s) 333
38: where rtr.retrieval_rule_id = p_retrieval_rule_id;
39: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;

Line 102: -- hxc_retrieval_rules and PER_BUSINESS_GROUPS

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

Line 108: from per_business_groups pbg

104: -- the current business group context can be derived.
105: -- Remove this comment when the edit has been completed.
106: cursor csr_leg_code is
107: select pbg.legislation_code
108: from per_business_groups pbg
109: , hxc_retrieval_rules rtr
110: -- , EDIT_HERE table_name(s) 333
111: where rtr.retrieval_rule_id = p_retrieval_rule_id;
112: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;