APPS.HXC_HTR_BUS dependencies on HXC_RETRIEVAL_RULE_COMPS

Line 190: FROM hxc_retrieval_rule_comps rrc

186: SELECT 'Y'
187: FROM sys.dual
188: WHERE EXISTS (
189: SELECT 'x'
190: FROM hxc_retrieval_rule_comps rrc
191: WHERE rrc.time_recipient_id = p_time_recipient_id);
192:
193: CURSOR csr_chk_apc IS
194: SELECT 'Y'