APPS.OKL_LTE_INT_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 30: l_due_date AR_PAYMENT_SCHEDULES_ALL.DUE_DATE%type;

26: l_init_msg_list VARCHAR2(1) ;
27: l_msg_count NUMBER ;
28:
29: l_amt_applied AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%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;

Line 127: , AR_PAYMENT_SCHEDULES_ALL AR_PAY

123: , max(greatest(TRUNC((FND_DATE.canonical_to_date(NVL(rul_hld.rule_information1,AR_PAY.DUE_DATE)))),TRUNC(AR_PAY.DUE_DATE))) DUE_DATE
124: , TRUNC(CRA.RECEIPT_DATE) RECEIPT_DATE
125: ,max('AR-INVOICE') invoice_flag
126: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC
127: , AR_PAYMENT_SCHEDULES_ALL AR_PAY
128: , OKL_K_HEADERS_FULL_V KHR
129: , OKC_RULE_GROUPS_B RGP
130: , OKC_RULES_B RUL
131: , okc_rules_b rul_exm

Line 200: , AR_PAYMENT_SCHEDULES_ALL AR_PAY

196: , max(greatest(TRUNC((FND_DATE.canonical_to_date(NVL(rul_hld.rule_information1,AR_PAY.DUE_DATE)))),TRUNC(AR_PAY.DUE_DATE))) DUE_DATE
197: , TRUNC(CRA.RECEIPT_DATE) RECEIPT_DATE
198: ,max('AR-INVOICE') invoice_flag
199: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC
200: , AR_PAYMENT_SCHEDULES_ALL AR_PAY
201: , OKL_K_HEADERS_FULL_V KHR
202: , OKC_RULE_GROUPS_B RGP
203: , OKC_RULES_B RUL
204: , okc_rules_b rul_exm

Line 285: , AR_PAYMENT_SCHEDULES_ALL AR_PAY

281: , max(greatest(TRUNC((FND_DATE.canonical_to_date(NVL(rul_hld.rule_information1,AR_PAY.DUE_DATE)))),TRUNC(AR_PAY.DUE_DATE))) DUE_DATE
282: , TRUNC(CRA.RECEIPT_DATE) RECEIPT_DATE
283: , max('CONS-INVOICE') invoice_flag
284: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC
285: , AR_PAYMENT_SCHEDULES_ALL AR_PAY
286: , OKL_CNSLD_AR_STRMS_B CNSLD
287: , OKL_K_HEADERS_FULL_V KHR
288: , OKC_RULE_GROUPS_B RGP
289: , OKC_RULES_B RUL