DBA Data[Home] [Help]

APPS.OKL_CASH_APPL_RULES dependencies on OKL_TXL_RCPT_APPS_V

Line 139: l_rca_id OKL_TXL_RCPT_APPS_V.ID%TYPE;

135: l_stream_tot NUMBER := 0;
136: l_pro_rate_inv_total NUMBER := 0;
137:
138: l_rct_id OKL_TRX_CSH_RECEIPT_B.ID%TYPE;
139: l_rca_id OKL_TXL_RCPT_APPS_V.ID%TYPE;
140: l_xcr_id NUMBER;
141:
142: l_sty_id OKL_CNSLD_AR_STRMS_V.STY_ID%TYPE;
143:

Line 400: FROM OKL_TRX_CSH_RECEIPT_V a, OKL_TXL_RCPT_APPS_V b

396: ,cp_check_num IN VARCHAR2
397: ,cp_amount IN NUMBER
398: ,cp_cons_bill_id IN NUMBER) IS
399: SELECT a.id, b.id
400: FROM OKL_TRX_CSH_RECEIPT_V a, OKL_TXL_RCPT_APPS_V b
401: WHERE a.id = b.rct_id_details
402: AND a.ile_id = cp_customer_id
403: AND a.check_number = cp_check_num
404: AND a.amount = cp_amount

Line 415: FROM OKL_TRX_CSH_RECEIPT_V a, OKL_TXL_RCPT_APPS_V b

411: ,cp_check_num IN VARCHAR2
412: ,cp_amount IN NUMBER
413: ,cp_contract_id IN NUMBER) IS
414: SELECT a.id, b.id
415: FROM OKL_TRX_CSH_RECEIPT_V a, OKL_TXL_RCPT_APPS_V b
416: WHERE a.id = b.rct_id_details
417: AND a.ile_id = cp_customer_id
418: AND a.check_number = cp_check_num
419: AND a.amount = cp_amount