APPS.POS_CLM_UTIL_PKG dependencies on HR_LOCATIONS_ALL

Line 885: FROM HR_LOCATIONS_ALL

881: INTO x_ship_addr1,
882: x_ship_addr2,
883: x_ship_addr3,
884: x_ship_city_state
885: FROM HR_LOCATIONS_ALL
886: WHERE LOCATION_ID = p_ship_to_loc_id;
887:
888: EXCEPTION WHEN OTHERS THEN
889: x_ship_addr1 := NULL;

Line 907: FROM HR_LOCATIONS_ALL

903: INTO x_bill_addr1,
904: x_bill_addr2,
905: x_bill_addr3,
906: x_bill_city_state
907: FROM HR_LOCATIONS_ALL
908: WHERE LOCATION_ID = p_bill_to_loc_id;
909:
910:
911: EXCEPTION WHEN OTHERS THEN