APPS.HZ_EXTRACT_BO_UTIL_PVT dependencies on HZ_ORG_CONTACTS

Line 296: FROM HZ_ORG_CONTACTS

292: AND contact_point_type = l_cp_type;
293:
294: CURSOR is_oc_valid(l_oc_id NUMBER) IS
295: SELECT 'X'
296: FROM HZ_ORG_CONTACTS
297: WHERE org_contact_id = l_oc_id;
298:
299: CURSOR is_pty_valid(l_pty_id NUMBER, l_pty_type VARCHAR2) IS
300: SELECT 'X'

Line 364: ELSIF(p_obj_type = 'HZ_ORG_CONTACTS') THEN

360: IF(p_obj_type in ('PHONE','TLX','EMAIL','WEB','EFT','EDI','SMS')) THEN
361: OPEN is_cp_valid(px_id, p_obj_type);
362: FETCH is_cp_valid INTO l_valid_id;
363: CLOSE is_cp_valid;
364: ELSIF(p_obj_type = 'HZ_ORG_CONTACTS') THEN
365: OPEN is_oc_valid(px_id);
366: FETCH is_oc_valid INTO l_valid_id;
367: CLOSE is_oc_valid;
368: ELSIF(p_obj_type in ('PERSON','ORGANIZATION','PARTY_RELATIONSHIP')) THEN