[Home] [Help]
157: SELECT
158: BATCH_NAME
159: INTO L_INVOICE_BATCH
160: FROM
161: AP_BATCHES_ALL
162: WHERE BATCH_ID = C_INVOICE_BATCH_ID
163: AND ROWNUM < 2;
164: EXCEPTION
165: WHEN NO_DATA_FOUND THEN