APPS.HXT_HXC_RETRIEVAL_PROCESS dependencies on HXC_RETRIEVAL_RULE_COMPS

Line 1682: FROM hxc_retrieval_rule_comps rrc,

1678: -- retrieves list of time recipients in retrieval rule group
1679: CURSOR csr_get_rtr (p_rtr_id NUMBER)
1680: IS
1681: SELECT DISTINCT (rrc.time_recipient_id)
1682: FROM hxc_retrieval_rule_comps rrc,
1683: hxc_retrieval_rules rr
1684: WHERE rr.retrieval_rule_id = p_rtr_id
1685: AND rrc.retrieval_rule_id = rr.retrieval_rule_id
1686: AND rrc.status <> 'WORKING';