DBA Data[Home] [Help]

APPS.CSP_REPAIR_PO_GRP dependencies on HR_ORGANIZATION_UNITS

Line 273: FROM HR_ORGANIZATION_UNITS

269: /*
270: Begin
271: SELECT LOCATION_ID
272: INTO l_supplier_org_location_id
273: FROM HR_ORGANIZATION_UNITS
274: WHERE ORGANIZATION_ID = L_repair_supplier_org_id;
275: Exception
276: When no_data_found then
277: l_supplier_org_location_id := Null;

Line 360: FROM HR_ORGANIZATION_UNITS

356:
357: Begin
358: SELECT LOCATION_ID
359: INTO l_supplier_org_location_id
360: FROM HR_ORGANIZATION_UNITS
361: WHERE ORGANIZATION_ID = L_repair_supplier_org_id;
362: Exception
363: When no_data_found then
364: --l_supplier_org_location_id := Null;

Line 404: FROM HR_ORGANIZATION_UNITS

400:
401: Begin
402: SELECT LOCATION_ID
403: INTO l_ship_to_location_id
404: FROM HR_ORGANIZATION_UNITS
405: WHERE ORGANIZATION_ID = P_dest_organization_id;
406: Exception
407: When no_data_found then
408: --l_ship_to_location_id := Null;