318: and nvl(disable_date, sysdate) >= sysdate
319: and organization_id= p_ship_to_org_id;
320:
321: Cursor c_check_rec_loc IS
322: Select 'x' from okx_locations_v ocv
323: where organization_id = p_ship_to_org_id
324: and id1= p_ship_to_loc_id;
325:
326: Cursor c_check_vendor IS
379: and nvl(disable_date, sysdate) >= sysdate
380: and organization_id= p_ship_from_org_id;
381:
382: Cursor c_check_ship_from_loc IS
383: Select 'x' from okx_locations_v ocv
384: where organization_id = p_ship_from_org_id
385: and id1= p_ship_from_loc_id;
386:
387: Cursor c_check_customer IS