APPS.HXC_RET_RULE_GRP_COMP_API dependencies on HXC_RETRIEVAL_RULE_GRP_COMPS_V

Line 719: , hxc_retrieval_rule_grp_comps_v rrc

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
723: AND rr2.retrieval_rule_id = rrc.retrieval_rule_id