APPS.OKL_LTE_INT_PVT dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 29: l_amt_applied AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%type;

25: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
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: l_apply_date AR_RECEIVABLE_APPLICATIONS_ALL.APPLY_DATE%TYPE;
33: l_cnsld_id OKL_CNSLD_AR_STRMS_V.ID%type;

Line 32: l_apply_date AR_RECEIVABLE_APPLICATIONS_ALL.APPLY_DATE%TYPE;

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: l_apply_date AR_RECEIVABLE_APPLICATIONS_ALL.APPLY_DATE%TYPE;
33: l_cnsld_id OKL_CNSLD_AR_STRMS_V.ID%type;
34: l_amount NUMBER;
35: l_interest_amount NUMBER;
36:

Line 105: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC

101: , sum(NVL(ARL.AMOUNT_DUE_ORIGINAL,0)) AMOUNT_APPLIED
102: , max(greatest(TRUNC((FND_DATE.canonical_to_date(NVL(rul_hld.rule_information1,AR_PAY.DUE_DATE)))),TRUNC(AR_PAY.DUE_DATE))) DUE_DATE
103: , max(TRUNC(AR_REC.APPLY_DATE)) APPLY_DATE
104: ,max('AR-INVOICE') invoice_flag
105: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC
106: , AR_PAYMENT_SCHEDULES_ALL AR_PAY
107: , OKL_BPD_AR_INV_LINES_V ARL
108: , OKL_K_HEADERS_FULL_V KHR
109: , OKC_RULE_GROUPS_B RGP

Line 165: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC

161: , sum(NVL(AR_REC.AMOUNT_APPLIED,0)) AMOUNT_APPLIED
162: , max(greatest(TRUNC((FND_DATE.canonical_to_date(NVL(rul_hld.rule_information1,AR_PAY.DUE_DATE)))),TRUNC(AR_PAY.DUE_DATE))) DUE_DATE
163: , max(TRUNC(AR_REC.APPLY_DATE)) APPLY_DATE
164: , max('CONS-INVOICE') invoice_flag
165: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC
166: , AR_PAYMENT_SCHEDULES_ALL AR_PAY
167: , OKL_CNSLD_AR_STRMS_B CNSLD
168: , OKL_K_HEADERS_FULL_V KHR
169: , OKC_RULE_GROUPS_B RGP