APPS.OKL_LTE_CHRG_PVT dependencies on OKL_CNSLD_AR_STRMS_B

Line 35: l_rec_inv_id OKL_CNSLD_AR_STRMS_B.RECEIVABLES_INVOICE_ID%type;

31: l_msg_count NUMBER ;
32:
33: i NUMBER := 0;
34:
35: l_rec_inv_id OKL_CNSLD_AR_STRMS_B.RECEIVABLES_INVOICE_ID%type;
36: l_rec_inv_contract_id NUMBER;
37: l_amt_due_remaining AR_PAYMENT_SCHEDULES_ALL.AMOUNT_DUE_REMAINING%type;
38: l_due_date AR_PAYMENT_SCHEDULES_ALL.DUE_DATE%type;
39: l_khr_id OKL_CNSLD_AR_STRMS_B.KHR_ID%type;

Line 39: l_khr_id OKL_CNSLD_AR_STRMS_B.KHR_ID%type;

35: l_rec_inv_id OKL_CNSLD_AR_STRMS_B.RECEIVABLES_INVOICE_ID%type;
36: l_rec_inv_contract_id NUMBER;
37: l_amt_due_remaining AR_PAYMENT_SCHEDULES_ALL.AMOUNT_DUE_REMAINING%type;
38: l_due_date AR_PAYMENT_SCHEDULES_ALL.DUE_DATE%type;
39: l_khr_id OKL_CNSLD_AR_STRMS_B.KHR_ID%type;
40: l_sty_id OKL_STRM_TYPE_V.ID%TYPE;
41: l_stm_id OKL_STREAMS_V.ID%TYPE;
42: l_late_stm_id OKL_STREAMS_V.ID%TYPE;
43: l_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;

Line 173: ,OKL_CNSLD_AR_STRMS_B ST

169: ,HD.consolidated_invoice_number
170: ,sum(PS.amount_due_remaining) amount_due_remaining
171: ,PS.due_date
172: from AR_PAYMENT_SCHEDULES_ALL PS
173: ,OKL_CNSLD_AR_STRMS_B ST
174: ,OKL_CNSLD_AR_HDRS_B HD
175: ,OKC_K_HEADERS_ALL_B CN
176: ,OKL_CNSLD_AR_LINES_B LN
177: ,OKL_STRM_TYPE_B SM

Line 336: OKL_CNSLD_AR_STRMS_B ST,

332: PS.CLASS CLASS ,
333: SM.ID STREAM_TYPE_ID,
334: PS.STATUS STATUS
335: FROM AR_PAYMENT_SCHEDULES_ALL PS,
336: OKL_CNSLD_AR_STRMS_B ST,
337: OKL_CNSLD_AR_HDRS_B HD,
338: OKC_K_HEADERS_ALL_B CN,
339: OKL_CNSLD_AR_LINES_B LN,
340: OKL_STRM_TYPE_B SM

Line 361: OKL_CNSLD_AR_STRMS_B ST,

357: PS.CLASS CLASS ,
358: SM.ID STREAM_TYPE_ID,
359: PS.STATUS STATUS
360: FROM AR_PAYMENT_SCHEDULES_ALL PS,
361: OKL_CNSLD_AR_STRMS_B ST,
362: OKL_CNSLD_AR_HDRS_B HD,
363: OKC_K_HEADERS_ALL_B CN,
364: OKL_CNSLD_AR_LINES_B LN,
365: OKL_STRM_TYPE_B SM

Line 436: FROM OKL_CNSLD_AR_STRMS_B lsm,

432: CURSOR l_cons_lsm_cur(l_consolidated_invoice_id IN NUMBER, l_khr_id in number) IS
433: SELECT lsm.id
434: , LATE_CHARGE_ASS_YN
435: , LATE_CHARGE_ASSESS_DATE
436: FROM OKL_CNSLD_AR_STRMS_B lsm,
437: OKL_CNSLD_AR_LINES_B lln,
438: OKL_CNSLD_AR_HDRS_B cnr
439: WHERE cnr.id = l_consolidated_invoice_id
440: and lln.cnr_id = cnr.id

Line 547: okl_cnsld_ar_strms_b lsm

543:
544: CURSOR c_sec_strm_cons_csr(l_consolidated_invoice_id IN NUMBER, l_khr_id in number) IS
545: select lsm.id cnsld_strm_id, pol.khr_id, ps.amount_due_remaining,lsm.kle_id
546: from
547: okl_cnsld_ar_strms_b lsm
548: , okl_cnsld_ar_hdrs_b cnr
549: , okl_cnsld_ar_lines_b lln
550: , okl_pool_contents_v pk
551: -- , okl_pools_v pol

Line 1265: Update okl_cnsld_ar_strms_b

1261: -- if consolidated Invoice
1262: IF l_inv_cur.consolidated_invoice_id is not null then
1263: FOR l_lsm IN l_cons_lsm_cur(l_inv_cur.consolidated_invoice_id , l_khr_id) --Added by bkatraga for bug 5601733
1264: LOOP
1265: Update okl_cnsld_ar_strms_b
1266: set LATE_CHARGE_ASS_YN = 'Y'
1267: ,LATE_CHARGE_ASSESS_DATE = SYSDATE
1268: ,last_updated_by = l_last_updated_by
1269: ,last_update_date = sysdate