DBA Data[Home] [Help]

APPS.HXC_RRC_UPLOAD_PKG dependencies on HXC_RETRIEVAL_RULE_GROUPS_V

Line 10: FROM hxc_retrieval_rule_groups_v

6: FUNCTION get_retrieval_rule_group_id ( p_retrieval_rule_group_name IN VARCHAR2 ) RETURN NUMBER IS
7:
8: CURSOR csr_get_rtr_group_id IS
9: SELECT retrieval_rule_group_id
10: FROM hxc_retrieval_rule_groups_v
11: WHERE retrieval_rule_group_name = p_retrieval_rule_group_name;
12:
13: l_retrieval_rule_group_id hxc_entity_groups.entity_group_id%TYPE;
14:

Line 83: FROM hxc_retrieval_rule_groups_v rrg

79: , DECODE( NVL( rrc.last_updated_by,-1), 1, 'SEED', 'CUSTOM')
80: INTO l_rtr_group_comp_id
81: , l_ovn
82: , l_owner
83: FROM hxc_retrieval_rule_groups_v rrg
84: , hxc_retrieval_rule_grp_comps_v rrc
85: WHERE rrc.retrieval_rule_id = l_retrieval_rule_id
86: AND rrc.retrieval_rule_group_id = rrg.retrieval_rule_group_id
87: AND rrg.retrieval_rule_group_id = l_retrieval_rule_group_id;