DBA Data[Home] [Help]

APPS.JMF_SHIKYU_PO_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 397: FROM hr_all_organization_units

393:
394: BEGIN
395: SELECT location_id
396: INTO l_ship_to_location_id
397: FROM hr_all_organization_units
398: WHERE organization_id = l_subcontract_orders_rec.tp_organization_id;
399: EXCEPTION
400: WHEN NO_DATA_FOUND THEN
401: l_ship_to_location_id := NULL;