APPS.HXC_ABS_RETRIEVAL_PKG dependencies on HXC_RETRIEVAL_RULE_GRP_COMPS_V

Line 2775: hxc_retrieval_rule_grp_comps_v rrgc,

2771: SELECT rrc.status
2772: INTO l_ret_status
2773: FROM hxc_retrieval_rule_comps rrc,
2774: hxc_retrieval_rules rr,
2775: hxc_retrieval_rule_grp_comps_v rrgc,
2776: hxc_retrieval_rule_groups_v rrg
2777: WHERE rrg.retrieval_rule_group_id = p_retrieval_rule_grp_id
2778: AND rrgc.retrieval_rule_group_id = rrg.retrieval_rule_group_id
2779: AND rrgc.retrieval_process_id = g_retrieval_process_id