APPS.HXC_DRU_BUS dependencies on HXC_DATA_APP_RULE_USAGES

Line 28: -- hxc_data_app_rule_usages and PER_BUSINESS_GROUPS

24: --
25: -- Declare cursor
26: --
27: -- EDIT_HERE In the following cursor statement add join(s) between
28: -- hxc_data_app_rule_usages 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_data_app_rule_usages dru

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_data_app_rule_usages dru
36: -- , EDIT_HERE table_name(s) 333
37: where dru.data_app_rule_usage_id = p_data_app_rule_usage_id;
38: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
39: --

Line 99: -- hxc_data_app_rule_usages and PER_BUSINESS_GROUPS

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

Line 106: , hxc_data_app_rule_usages dru

102: -- Remove this comment when the edit has been completed.
103: cursor csr_leg_code is
104: select pbg.legislation_code
105: from per_business_groups pbg
106: , hxc_data_app_rule_usages dru
107: -- , EDIT_HERE table_name(s) 333
108: where dru.data_app_rule_usage_id = p_data_app_rule_usage_id;
109: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
110: --

Line 267: p_approval_style_id in hxc_data_app_rule_usages.approval_style_id%TYPE,

263: -- {End Of Comments}
264: -- ----------------------------------------------------------------------------
265: Procedure chk_dependency_rule
266: (
267: p_approval_style_id in hxc_data_app_rule_usages.approval_style_id%TYPE,
268: p_time_entry_rule_id in hxc_data_app_rule_usages.time_entry_rule_id%TYPE,
269: p_time_recipient_id in hxc_data_app_rule_usages.time_recipient_id%TYPE,
270: p_object_version_number in hxc_data_app_rule_usages.object_version_number%TYPE
271: ) IS

Line 268: p_time_entry_rule_id in hxc_data_app_rule_usages.time_entry_rule_id%TYPE,

264: -- ----------------------------------------------------------------------------
265: Procedure chk_dependency_rule
266: (
267: p_approval_style_id in hxc_data_app_rule_usages.approval_style_id%TYPE,
268: p_time_entry_rule_id in hxc_data_app_rule_usages.time_entry_rule_id%TYPE,
269: p_time_recipient_id in hxc_data_app_rule_usages.time_recipient_id%TYPE,
270: p_object_version_number in hxc_data_app_rule_usages.object_version_number%TYPE
271: ) IS
272: --

Line 269: p_time_recipient_id in hxc_data_app_rule_usages.time_recipient_id%TYPE,

265: Procedure chk_dependency_rule
266: (
267: p_approval_style_id in hxc_data_app_rule_usages.approval_style_id%TYPE,
268: p_time_entry_rule_id in hxc_data_app_rule_usages.time_entry_rule_id%TYPE,
269: p_time_recipient_id in hxc_data_app_rule_usages.time_recipient_id%TYPE,
270: p_object_version_number in hxc_data_app_rule_usages.object_version_number%TYPE
271: ) IS
272: --
273: l_proc varchar2(72);

Line 270: p_object_version_number in hxc_data_app_rule_usages.object_version_number%TYPE

266: (
267: p_approval_style_id in hxc_data_app_rule_usages.approval_style_id%TYPE,
268: p_time_entry_rule_id in hxc_data_app_rule_usages.time_entry_rule_id%TYPE,
269: p_time_recipient_id in hxc_data_app_rule_usages.time_recipient_id%TYPE,
270: p_object_version_number in hxc_data_app_rule_usages.object_version_number%TYPE
271: ) IS
272: --
273: l_proc varchar2(72);
274: --

Line 283: FROM hxc_data_app_rule_usages dru

279: SELECT 'error'
280: FROM sys.dual
281: WHERE EXISTS (
282: SELECT 'x'
283: FROM hxc_data_app_rule_usages dru
284: WHERE dru.approval_style_id = p_approval_style_id
285: AND dru.time_recipient_id = p_time_recipient_id
286: AND dru.time_entry_rule_id = p_time_entry_rule_id
287: AND dru.object_version_number <> NVL(p_object_version_number, -1) );