APPS.OKL_LTE_INT_PVT dependencies on AR_CASH_RECEIPTS_ALL

Line 34: l_receipt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE;

30: l_due_date AR_PAYMENT_SCHEDULES_ALL.DUE_DATE%type;
31: l_khr_id OKL_CNSLD_AR_STRMS_V.KHR_ID%type;
32:
33: --Bug# 11076575: Changed l_apply_date to l_receipt_date
34: l_receipt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE;
35:
36: l_cnsld_id OKL_CNSLD_AR_STRMS_V.ID%type;
37: l_amount NUMBER;
38: l_interest_amount NUMBER;

Line 134: , AR_CASH_RECEIPTS_ALL CRA

130: , OKC_RULES_B RUL
131: , okc_rules_b rul_exm
132: ,okc_rules_b rul_hld
133: , OKL_LATE_POLICIES_V LTE
134: , AR_CASH_RECEIPTS_ALL CRA
135: , RA_CUSTOMER_TRX_LINES_ALL RACTRL
136: , OKL_TXD_AR_LN_DTLS_B TXD
137: , AR_DISTRIBUTIONS_ALL AD
138: WHERE

Line 207: , AR_CASH_RECEIPTS_ALL CRA

203: , OKC_RULES_B RUL
204: , okc_rules_b rul_exm
205: ,okc_rules_b rul_hld
206: , OKL_LATE_POLICIES_V LTE
207: , AR_CASH_RECEIPTS_ALL CRA
208: , RA_CUSTOMER_TRX_LINES_ALL RACTRL
209: , RA_CUSTOMER_TRX_LINES_ALL RACTRL_TAX
210: , OKL_TXD_AR_LN_DTLS_B TXD
211: , AR_DISTRIBUTIONS_ALL AD

Line 293: , AR_CASH_RECEIPTS_ALL CRA

289: , OKC_RULES_B RUL
290: , okc_rules_b rul_exm
291: ,okc_rules_b rul_hld
292: , OKL_LATE_POLICIES_V LTE
293: , AR_CASH_RECEIPTS_ALL CRA
294: WHERE
295: CRA.RECEIPT_DATE > (AR_PAY.DUE_DATE + nvl(LTE.late_int_grace_period, 0)) AND
296: CNSLD.RECEIVABLES_INVOICE_ID = AR_PAY.CUSTOMER_TRX_ID
297: AND AR_PAY.PAYMENT_SCHEDULE_ID = AR_REC.APPLIED_PAYMENT_SCHEDULE_ID