APPS.OKL_SSC_WF dependencies on AR_CASH_RECEIPTS_ALL

Line 3268: xl_payment_ref_number AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE DEFAULT NULL;

3264: --END: Fixed Bug 5697488
3265: pl_account_holder_name VARCHAR2(15);
3266: pl_account_type VARCHAR2(15) default null;
3267: pl_expiration_date DATE;
3268: xl_payment_ref_number AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE DEFAULT NULL;
3269: l_cust_id NUMBER;
3270:
3271: -- Begin - Varangan- for Oracle Payments Uptake
3272: pl_customer_trx_id NUMBER;

Line 3413: FROM ar_cash_receipts_all

3409: IS
3410:
3411: CURSOR cust_id_info_cur(p_payment_id IN NUMBER) IS
3412: SELECT pay_from_customer cust_account_id
3413: FROM ar_cash_receipts_all
3414: WHERE cash_receipt_id = p_payment_id;
3415:
3416: CURSOR cust_name_info_cur(p_cust_id IN NUMBER) IS
3417: SELECT account_name