[Home] [Help]
870: SELECT
871: A.EXCISE_INVOICE_NO
872: INTO V_EXCISE_INV_NO
873: FROM
874: JAI_AR_TRX_LINES A
875: WHERE CUSTOMER_TRX_ID = CUSTOMER_TRX_ID_1
876: AND A.EXCISE_INVOICE_NO IS NOT NULL
877: AND ROWNUM = 1;
878: CP_EXCISE_INV_NO := V_EXCISE_INV_NO;