APPS.HXC_RTC_BUS dependencies on HXC_RETRIEVAL_RULE_COMPS

Line 29: -- hxc_retrieval_rule_comps and PER_BUSINESS_GROUPS

25: --
26: -- Declare cursor
27: --
28: -- EDIT_HERE In the following cursor statement add join(s) between
29: -- hxc_retrieval_rule_comps 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 36: , hxc_retrieval_rule_comps rtc

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_rule_comps rtc
37: -- , EDIT_HERE table_name(s) 333
38: where rtc.retrieval_rule_comp_id = p_retrieval_rule_comp_id;
39: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
40: --

Line 102: -- hxc_retrieval_rule_comps and PER_BUSINESS_GROUPS

98: --
99: -- Declare cursor
100: --
101: -- EDIT_HERE In the following cursor statement add join(s) between
102: -- hxc_retrieval_rule_comps 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 109: , hxc_retrieval_rule_comps rtc

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_rule_comps rtc
110: -- , EDIT_HERE table_name(s) 333
111: where rtc.retrieval_rule_comp_id = p_retrieval_rule_comp_id;
112: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
113: --

Line 270: p_retrieval_rule_id in hxc_retrieval_rule_comps.retrieval_rule_id%TYPE,

266: -- {End Of Comments}
267: -- ----------------------------------------------------------------------------
268: Procedure chk_application
269: (
270: p_retrieval_rule_id in hxc_retrieval_rule_comps.retrieval_rule_id%TYPE,
271: p_time_recipient_id in hxc_retrieval_rule_comps.time_recipient_id%TYPE,
272: p_object_version_number in hxc_retrieval_rule_comps.object_version_number%TYPE
273: ) IS
274: --

Line 271: p_time_recipient_id in hxc_retrieval_rule_comps.time_recipient_id%TYPE,

267: -- ----------------------------------------------------------------------------
268: Procedure chk_application
269: (
270: p_retrieval_rule_id in hxc_retrieval_rule_comps.retrieval_rule_id%TYPE,
271: p_time_recipient_id in hxc_retrieval_rule_comps.time_recipient_id%TYPE,
272: p_object_version_number in hxc_retrieval_rule_comps.object_version_number%TYPE
273: ) IS
274: --
275: l_proc varchar2(72);

Line 272: p_object_version_number in hxc_retrieval_rule_comps.object_version_number%TYPE

268: Procedure chk_application
269: (
270: p_retrieval_rule_id in hxc_retrieval_rule_comps.retrieval_rule_id%TYPE,
271: p_time_recipient_id in hxc_retrieval_rule_comps.time_recipient_id%TYPE,
272: p_object_version_number in hxc_retrieval_rule_comps.object_version_number%TYPE
273: ) IS
274: --
275: l_proc varchar2(72);
276: --

Line 284: FROM hxc_retrieval_rule_comps rtc

280: SELECT 'error'
281: FROM sys.dual
282: WHERE EXISTS (
283: SELECT 'x'
284: FROM hxc_retrieval_rule_comps rtc
285: WHERE rtc.time_recipient_id = p_time_recipient_id
286: AND rtc.retrieval_rule_id = p_retrieval_rule_id
287: AND rtc.object_version_number <> NVL(p_object_version_number, -1) );
288: --