APPS.HXC_RET_RULE_GRP_COMP_API dependencies on HXC_RETRIEVAL_RULES_V

Line 714: FROM hxc_retrieval_rules_v rr1

710: OR p_ret_rule_grp_comp_id IS NULL ));
711:
712: CURSOR csr_chk_rr_ret_proc IS
713: SELECT 'error'
714: FROM hxc_retrieval_rules_v rr1
715: WHERE rr1.retrieval_rule_id = p_retrieval_rule_id
716: AND EXISTS (
717: SELECT 'x'
718: FROM hxc_retrieval_rules_v rr2

Line 718: FROM hxc_retrieval_rules_v rr2

714: FROM hxc_retrieval_rules_v rr1
715: WHERE rr1.retrieval_rule_id = p_retrieval_rule_id
716: AND EXISTS (
717: SELECT 'x'
718: FROM hxc_retrieval_rules_v rr2
719: , hxc_retrieval_rule_grp_comps_v rrc
720: , hxc_retrieval_rule_groups_v rrg
721: WHERE rrg.retrieval_rule_group_id = p_retrieval_rule_grp_id
722: AND rrc.retrieval_rule_group_id = rrg.retrieval_rule_group_id