APPS.HZ_EXTRACT_BO_UTIL_PVT dependencies on HZ_LOCATIONS

Line 317: FROM HZ_LOCATIONS

313: WHERE party_site_id = l_ps_id;
314:
315: CURSOR is_loc_valid(l_loc_id NUMBER) IS
316: SELECT 'X'
317: FROM HZ_LOCATIONS
318: WHERE location_id = l_loc_id;
319:
320: CURSOR is_cr_valid(l_cr_id NUMBER) IS
321: SELECT 'X'

Line 380: ELSIF(p_obj_type = 'HZ_LOCATIONS') THEN

376: ELSIF(p_obj_type = 'HZ_CUST_ACCOUNT_ROLES') THEN
377: OPEN is_cr_valid(px_id);
378: FETCH is_cr_valid INTO l_valid_id;
379: CLOSE is_cr_valid;
380: ELSIF(p_obj_type = 'HZ_LOCATIONS') THEN
381: OPEN is_loc_valid(px_id);
382: FETCH is_loc_valid INTO l_valid_id;
383: CLOSE is_loc_valid;
384: ELSIF(p_obj_type = 'HZ_PARTY_SITES') THEN