APPS.HXC_HPH_BUS dependencies on PER_BUSINESS_GROUPS

Line 28: -- hxc_pref_hierarchies and PER_BUSINESS_GROUPS

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

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
33: select pbg.security_group_id
34: from per_business_groups pbg
35: , hxc_pref_hierarchies hph
36: -- , EDIT_HERE table_name(s) 333
37: where hph.pref_hierarchy_id = p_pref_hierarchy_id;
38: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;

Line 100: -- hxc_pref_hierarchies and PER_BUSINESS_GROUPS

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

Line 106: from per_business_groups pbg

102: -- the current business group context can be derived.
103: -- Remove this comment when the edit has been completed.
104: cursor csr_leg_code is
105: select pbg.legislation_code
106: from per_business_groups pbg
107: , hxc_pref_hierarchies hph
108: -- , EDIT_HERE table_name(s) 333
109: where hph.pref_hierarchy_id = p_pref_hierarchy_id;
110: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;

Line 1600: l_lc per_business_groups.legislation_code%TYPE;

1596: --
1597: -- Local declarations
1598: l_proc varchar2(72);
1599: l_territory_code fnd_territories.territory_code%TYPE;
1600: l_lc per_business_groups.legislation_code%TYPE;
1601: --
1602: -- Setup cursor for valid legislation code check
1603: cursor csr_valid_legislation_code is
1604: select territory_code

Line 1611: from per_business_groups pbg

1607:
1608: -- Setup cursor for valid legislation code for a particular business_group
1609: cursor csr_valid_bg_lc is
1610: select legislation_code
1611: from per_business_groups pbg
1612: where pbg.business_group_id = p_business_group_id
1613: and pbg.legislation_code = p_legislation_code;
1614:
1615: --