APPS.OKL_BPD_CAP_PURPOSE_PVT dependencies on AR_CASH_RECEIPTS_ALL

Line 32: l_cust_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL;

28: -- DECLARE Local Variables
29: ---------------------------
30: l_strm_rec okl_cash_dtls_rec_type;
31: l_strm_tbl okl_cash_dtls_tbl_type;
32: l_cust_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL;
33: l_rct_id_details OKL_TXL_RCPT_APPS_B.RCT_ID_DETAILS%TYPE DEFAULT NULL;
34: l_total_amount_applied OKL_TXL_RCPT_APPS_B.AMOUNT%TYPE DEFAULT NULL;
35: l_receipt_amount OKL_TXL_RCPT_APPS_B.AMOUNT%TYPE DEFAULT NULL;
36: l_org_id OKL_TXL_RCPT_APPS_B.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();

Line 81: FROM ar_cash_receipts_all b

77: --asawanka modified cursor for receipts project
78: CURSOR c_get_recpt_amt (cp_receipt_id IN l_strm_rec.receipt_id%TYPE)
79: IS
80: SELECT amount
81: FROM ar_cash_receipts_all b
82: WHERE b.cash_receipt_id = cp_receipt_id;
83: ----------
84:
85: -- get org_id for contract