339: IF l_Customer_Trx_Id is not null
340: THEN
341: SELECT Trx_Number
342: INTO l_invoice_num_temp
343: FROM Ra_Customer_Trx_All
344: WHERE Customer_Trx_Id = l_Customer_Trx_Id;
345: ELSE
346: l_invoice_num_temp:='';
347: END IF;
366: IF L_CUSTOMER_TRX_ID IS NOT NULL
367: THEN
368: SELECT Trx_Number
369: INTO x_Invoice_Num
370: FROM Ra_Customer_Trx_All
371: WHERE Customer_Trx_Id = l_Customer_Trx_Id;
372: ELSE
373: X_INVOICE_NUM:=to_char(null);
374: END IF; --L_CUSTOMER_TRX_ID IS NOT NULL