APPS.POS_ASN_XML dependencies on HR_LOCATIONS_ALL

Line 412: FROM hr_locations_all

408: ELSE /* use edi_code */
409:
410: SELECT count(*)
411: INTO l_count_num
412: FROM hr_locations_all
413: WHERE ece_tp_location_code = p_ship_to_partner_id;
414:
415: if (l_count_num = 0) then
416:

Line 425: FROM hr_locations_all

421: else
422:
423: SELECT min(location_id)
424: INTO p_ship_to_location_id
425: FROM hr_locations_all
426: WHERE ece_tp_location_code = p_ship_to_partner_id;
427:
428:
429: select count(*)