APPS.HXC_RRC_UPLOAD_PKG dependencies on HXC_RETRIEVAL_RULES

Line 29: FROM hxc_retrieval_rules

25: FUNCTION get_retrieval_rule_id ( p_name IN VARCHAR2 ) RETURN NUMBER IS
26:
27: CURSOR csr_get_retrieval_rule_id IS
28: SELECT retrieval_rule_id
29: FROM hxc_retrieval_rules
30: WHERE name = p_name;
31:
32: l_retrieval_rule_id hxc_retrieval_rules.retrieval_rule_id%TYPE;
33:

Line 32: l_retrieval_rule_id hxc_retrieval_rules.retrieval_rule_id%TYPE;

28: SELECT retrieval_rule_id
29: FROM hxc_retrieval_rules
30: WHERE name = p_name;
31:
32: l_retrieval_rule_id hxc_retrieval_rules.retrieval_rule_id%TYPE;
33:
34: BEGIN
35:
36: OPEN csr_get_retrieval_rule_id;