APPS.HZ_EXTRACT_BO_UTIL_PVT dependencies on HZ_ORG_CONTACTS

Line 300: FROM HZ_ORG_CONTACTS

296: AND contact_point_type = l_cp_type;
297:
298: CURSOR is_oc_valid(l_oc_id NUMBER) IS
299: SELECT 'X'
300: FROM HZ_ORG_CONTACTS
301: WHERE org_contact_id = l_oc_id;
302:
303: CURSOR is_pty_valid(l_pty_id NUMBER, l_pty_type VARCHAR2) IS
304: SELECT 'X'

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

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