APPS.OKL_PAYMENT_PVT dependencies on RA_CUSTOMER_TRX_ALL

Line 564: from ra_customer_trx_all

560: --Getting Trx Date
561: /*
562: Cursor c_get_date (l_orgid Number,l_customer_trx_id Number) Is
563: Select Trx_date apply_date
564: from ra_customer_trx_all
565: where customer_trx_id=l_customer_trx_id
566: and org_id=l_orgid;
567: */
568: ------------------------------------------------------------------------------

Line 587: FROM RA_CUSTOMER_TRX_ALL

583: ORDER BY CREATION_DATE DESC;
584:
585: CURSOR c_get_invoice_org_id(ar_inv_id IN NUMBER) IS
586: SELECT ORG_ID
587: FROM RA_CUSTOMER_TRX_ALL
588: WHERE CUSTOMER_TRX_ID = ar_inv_id;
589:
590: CURSOR c_get_cons_inv_org_id(cons_inv_id IN NUMBER) IS
591: SELECT ORG_ID