APPS.OKL_SSC_WF dependencies on AR_CASH_RECEIPTS_ALL

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

3178: --END: Fixed Bug 5697488
3179: pl_account_holder_name VARCHAR2(15);
3180: pl_account_type VARCHAR2(15) default null;
3181: pl_expiration_date DATE;
3182: xl_payment_ref_number AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE DEFAULT NULL;
3183: l_cust_id NUMBER;
3184:
3185: -- Begin - Varangan- for Oracle Payments Uptake
3186: pl_customer_trx_id NUMBER;

Line 3327: FROM ar_cash_receipts_all

3323: IS
3324:
3325: CURSOR cust_id_info_cur(p_payment_id IN NUMBER) IS
3326: SELECT pay_from_customer cust_account_id
3327: FROM ar_cash_receipts_all
3328: WHERE cash_receipt_id = p_payment_id;
3329:
3330: CURSOR cust_name_info_cur(p_cust_id IN NUMBER) IS
3331: SELECT account_name