APPS.HXC_ABS_RETRIEVAL_PKG dependencies on HXC_RETRIEVAL_RULE_COMPS

Line 2773: FROM hxc_retrieval_rule_comps rrc,

2769: RETURN g_ret_rules(p_retrieval_rule_grp_id).status;
2770: ELSE
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