APPS.HXT_HXC_RETRIEVAL_PROCESS dependencies on HXC_RETRIEVAL_RULES

Line 1710: hxc_retrieval_rules rr

1706: CURSOR csr_get_rtr (p_rtr_id NUMBER)
1707: IS
1708: SELECT DISTINCT (rrc.time_recipient_id)
1709: FROM hxc_retrieval_rule_comps rrc,
1710: hxc_retrieval_rules rr
1711: WHERE rr.retrieval_rule_id = p_rtr_id
1712: AND rrc.retrieval_rule_id = rr.retrieval_rule_id
1713: AND rrc.status <> 'WORKING';
1714: