DBA Data[Home] [Help]

APPS.JA_CN_CFS_REPORT_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 343: FROM Ra_Customer_Trx_All

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;

Line 370: FROM Ra_Customer_Trx_All

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