APPS.HXC_APC_BUS dependencies on HXC_APPROVAL_PERIOD_COMPS

Line 28: -- hxc_approval_period_comps and PER_BUSINESS_GROUPS

24: --
25: -- Declare cursor
26: --
27: -- EDIT_HERE In the following cursor statement add join(s) between
28: -- hxc_approval_period_comps 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 35: , hxc_approval_period_comps apc

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_approval_period_comps apc
36: -- , EDIT_HERE table_name(s) 333
37: where apc.approval_period_comp_id = p_approval_period_comp_id;
38: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
39: --

Line 100: -- hxc_approval_period_comps and PER_BUSINESS_GROUPS

96: --
97: -- Declare cursor
98: --
99: -- EDIT_HERE In the following cursor statement add join(s) between
100: -- hxc_approval_period_comps 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 107: , hxc_approval_period_comps apc

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_approval_period_comps apc
108: -- , EDIT_HERE table_name(s) 333
109: where apc.approval_period_comp_id = p_approval_period_comp_id;
110: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
111: --

Line 277: FROM hxc_approval_period_comps hapc

273: --
274: -- Bug 3035142
275: CURSOR csr_chk_app IS
276: SELECT 'error'
277: FROM hxc_approval_period_comps hapc
278: WHERE hapc.approval_period_set_id = p_approval_period_set_id
279: and hapc.time_recipient_id = p_time_recipient_id
280: and hapc.approval_period_comp_id <> nvl(p_approval_period_comp_id,hapc.approval_period_comp_id+1);
281: