APPS.POS_ASN_XML dependencies on HR_LOCATIONS_ALL

Line 391: FROM hr_locations_all

387: ELSE /* use edi_code */
388:
389: SELECT count(*)
390: INTO l_count_num
391: FROM hr_locations_all
392: WHERE ece_tp_location_code = p_ship_to_partner_id;
393:
394: if (l_count_num = 0) then
395:

Line 404: FROM hr_locations_all

400: else
401:
402: SELECT min(location_id)
403: INTO p_ship_to_location_id
404: FROM hr_locations_all
405: WHERE ece_tp_location_code = p_ship_to_partner_id;
406:
407:
408: select count(*)