APPS.ARH_DQM_TREE_HELPER dependencies on HZ_MATCHED_PARTY_SITES_GT

Line 28: INSERT INTO hz_matched_party_sites_gt

24: p_ps_id IN NUMBER)
25: IS
26: BEGIN
27: IF party_site_in_match (p_party_id , p_ctx_id , p_ps_id) = 'N' THEN
28: INSERT INTO hz_matched_party_sites_gt
29: (PARTY_ID ,PARTY_SITE_ID,SEARCH_CONTEXT_ID ,SCORE) VALUES
30: (p_party_id,p_ps_id ,p_ctx_id, 0);
31: END IF;
32: END;

Line 161: -- Return Y if p_cpt_id found in HZ_MATCHED_PARTY_SITES_GT

157: END;
158:
159: FUNCTION party_site_in_match
160: ----------------------------------------------------------
161: -- Return Y if p_cpt_id found in HZ_MATCHED_PARTY_SITES_GT
162: -- N otherwise
163: ----------------------------------------------------------
164: (p_party_id IN NUMBER,
165: p_ctx_id IN NUMBER,

Line 171: FROM hz_matched_party_sites_gt

167: RETURN VARCHAR2
168: IS
169: CURSOR c_exist IS
170: SELECT 'Y'
171: FROM hz_matched_party_sites_gt
172: WHERE party_id = p_party_id
173: AND search_context_id = p_ctx_id
174: AND party_site_id = p_ps_id;
175: ret VARCHAR2(1) := 'N';