APPS.OKL_BPD_CAP_ADV_MON_PVT dependencies on OKL_TXL_RCPT_APPS_V

Line 94: l_rca_id OKL_TXL_RCPT_APPS_V.ID%TYPE;

90: l_stream_tot NUMBER := 0;
91: l_pro_rate_inv_total NUMBER := 0;
92:
93: l_rct_id OKL_TRX_CSH_RECEIPT_B.ID%TYPE;
94: l_rca_id OKL_TXL_RCPT_APPS_V.ID%TYPE;
95: l_xcr_id NUMBER;
96:
97: l_dup_rcpt_flag NUMBER DEFAULT NULL;
98: l_cash_applied_flag VARCHAR2(1) DEFAULT NULL;

Line 186: FROM OKL_TRX_CSH_RECEIPT_V a, OKL_TXL_RCPT_APPS_V b

182: ,cp_check_num IN VARCHAR2
183: ,cp_amount IN NUMBER
184: ,cp_contract_id IN NUMBER) IS
185: SELECT a.id, b.id
186: FROM OKL_TRX_CSH_RECEIPT_V a, OKL_TXL_RCPT_APPS_V b
187: WHERE a.id = b.rct_id_details
188: AND a.ile_id = cp_customer_id
189: AND a.check_number = cp_check_num
190: AND a.amount = cp_amount