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 169: ,OKL_CNSLD_AR_STRMS_B ST

165: ,HD.consolidated_invoice_number
166: ,sum(PS.amount_due_remaining) amount_due_remaining
167: ,PS.due_date
168: from AR_PAYMENT_SCHEDULES_ALL PS
169: ,OKL_CNSLD_AR_STRMS_B ST
170: ,OKL_CNSLD_AR_HDRS_B HD
171: ,OKC_K_HEADERS_ALL_B CN
172: ,OKL_CNSLD_AR_LINES_B LN
173: ,OKL_STRM_TYPE_B SM

Line 331: OKL_CNSLD_AR_STRMS_B ST,

327: PS.CLASS CLASS ,
328: SM.ID STREAM_TYPE_ID,
329: PS.STATUS STATUS
330: FROM AR_PAYMENT_SCHEDULES_ALL PS,
331: OKL_CNSLD_AR_STRMS_B ST,
332: OKL_CNSLD_AR_HDRS_B HD,
333: OKC_K_HEADERS_ALL_B CN,
334: OKL_CNSLD_AR_LINES_B LN,
335: OKL_STRM_TYPE_B SM

Line 356: OKL_CNSLD_AR_STRMS_B ST,

352: PS.CLASS CLASS ,
353: SM.ID STREAM_TYPE_ID,
354: PS.STATUS STATUS
355: FROM AR_PAYMENT_SCHEDULES_ALL PS,
356: OKL_CNSLD_AR_STRMS_B ST,
357: OKL_CNSLD_AR_HDRS_B HD,
358: OKC_K_HEADERS_ALL_B CN,
359: OKL_CNSLD_AR_LINES_B LN,
360: OKL_STRM_TYPE_B SM

Line 431: FROM OKL_CNSLD_AR_STRMS_B lsm,

427: CURSOR l_cons_lsm_cur(l_consolidated_invoice_id IN NUMBER, l_khr_id in number) IS
428: SELECT lsm.id
429: , LATE_CHARGE_ASS_YN
430: , LATE_CHARGE_ASSESS_DATE
431: FROM OKL_CNSLD_AR_STRMS_B lsm,
432: OKL_CNSLD_AR_LINES_B lln,
433: OKL_CNSLD_AR_HDRS_B cnr
434: WHERE cnr.id = l_consolidated_invoice_id
435: and lln.cnr_id = cnr.id

Line 542: okl_cnsld_ar_strms_b lsm

538:
539: CURSOR c_sec_strm_cons_csr(l_consolidated_invoice_id IN NUMBER, l_khr_id in number) IS
540: select lsm.id cnsld_strm_id, pol.khr_id, ps.amount_due_remaining,lsm.kle_id
541: from
542: okl_cnsld_ar_strms_b lsm
543: , okl_cnsld_ar_hdrs_b cnr
544: , okl_cnsld_ar_lines_b lln
545: , okl_pool_contents_v pk
546: -- , okl_pools_v pol

Line 1258: Update okl_cnsld_ar_strms_b

1254: -- if consolidated Invoice
1255: IF l_inv_cur.consolidated_invoice_id is not null then
1256: FOR l_lsm IN l_cons_lsm_cur(l_inv_cur.consolidated_invoice_id , l_khr_id) --Added by bkatraga for bug 5601733
1257: LOOP
1258: Update okl_cnsld_ar_strms_b
1259: set LATE_CHARGE_ASS_YN = 'Y'
1260: ,LATE_CHARGE_ASSESS_DATE = SYSDATE
1261: ,last_updated_by = l_last_updated_by
1262: ,last_update_date = sysdate