[Home] [Help]
399: SELECT
400: LINE_NUMBER
401: INTO L_SOURCE_LINE_NUMBER
402: FROM
403: SO_LINES_ALL
404: WHERE LINE_ID = C_ORDER_LINE_ID
405: AND ROWNUM < 2;
406: EXCEPTION
407: WHEN NO_DATA_FOUND THEN
441: SELECT
442: LINE_NUMBER
443: INTO L_SOURCE_LINE_NUMBER
444: FROM
445: SO_LINES_ALL
446: WHERE LINE_ID = C_ORDER_LINE_ID
447: AND ROWNUM < 2;
448: EXCEPTION
449: WHEN NO_DATA_FOUND THEN