APPS.HXT_HXC_RETRIEVAL_PROCESS dependencies on HXC_RETRIEVAL_RULE_COMPS

Line 1709: FROM hxc_retrieval_rule_comps rrc,

1705: -- retrieves list of time recipients in retrieval rule group
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';