[Home] [Help]
428: SELECT
429: LINE_NUM
430: INTO L_SOURCE_LINE_NUMBER
431: FROM
432: PO_REQUISITION_LINES_ALL
433: WHERE REQUISITION_LINE_ID = C_REQUISITION_LINE_ID
434: AND ROWNUM < 2;
435: EXCEPTION
436: WHEN NO_DATA_FOUND THEN