DBA Data[Home] [Help]

APPS.HXT_HXC_RETRIEVAL_PROCESS dependencies on HXC_RETRIEVAL_RULES

Line 1683: hxc_retrieval_rules rr

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';
1687: