APPS.ARH_DQM_TREE_HELPER dependencies on HZ_MATCHED_PARTIES_GT

Line 9: FROM hz_matched_parties_gt;

5: RETURN NUMBER
6: IS
7: CURSOR c1 IS
8: SELECT MAX(search_context_id)
9: FROM hz_matched_parties_gt;
10: lret NUMBER;
11: BEGIN
12: OPEN c1;
13: FETCH c1 INTO lret;

Line 189: -- Return Y if p_party_id found in HZ_MATCHED_PARTIES_GT

185:
186:
187: FUNCTION party_in_match
188: --------------------------------------------------------
189: -- Return Y if p_party_id found in HZ_MATCHED_PARTIES_GT
190: -- N otherwise
191: --------------------------------------------------------
192: (p_party_id IN NUMBER,
193: p_ctx_id IN NUMBER)

Line 198: FROM hz_matched_parties_gt

194: RETURN VARCHAR2
195: IS
196: CURSOR c_exist IS
197: SELECT 'Y'
198: FROM hz_matched_parties_gt
199: WHERE party_id = p_party_id
200: AND search_context_id = p_ctx_id;
201: ret VARCHAR2(1) := 'N';
202: BEGIN