39: CURSOR csr_get_retrieval_rules ( p_rtr_grp_id NUMBER ) IS
40: SELECT
41: DISTINCT( rrc.time_recipient_id )
42: FROM
43: hxc_retrieval_rule_comps rrc
44: , hxc_retrieval_rules rr
45: , hxc_retrieval_rule_grp_comps_v rrgc
46: , hxc_retrieval_rule_groups_v rrg
47: WHERE
60: CURSOR csr_get_rtr ( p_rtr_id NUMBER ) IS
61: SELECT
62: DISTINCT( rrc.time_recipient_id )
63: FROM
64: hxc_retrieval_rule_comps rrc
65: , hxc_retrieval_rules rr
66: WHERE
67: rr.retrieval_rule_id = p_rtr_id
68: AND