APPS.HZ_EXTRACT_BO_UTIL_PVT dependencies on HZ_LOCATIONS

Line 313: FROM HZ_LOCATIONS

309: WHERE party_site_id = l_ps_id;
310:
311: CURSOR is_loc_valid(l_loc_id NUMBER) IS
312: SELECT 'X'
313: FROM HZ_LOCATIONS
314: WHERE location_id = l_loc_id;
315:
316: CURSOR is_cr_valid(l_cr_id NUMBER) IS
317: SELECT 'X'

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

372: ELSIF(p_obj_type = 'HZ_CUST_ACCOUNT_ROLES') THEN
373: OPEN is_cr_valid(px_id);
374: FETCH is_cr_valid INTO l_valid_id;
375: CLOSE is_cr_valid;
376: ELSIF(p_obj_type = 'HZ_LOCATIONS') THEN
377: OPEN is_loc_valid(px_id);
378: FETCH is_loc_valid INTO l_valid_id;
379: CLOSE is_loc_valid;
380: ELSIF(p_obj_type = 'HZ_PARTY_SITES') THEN