eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKL_STRM_ELEMENTS

Line 574: CURSOR strm_element_csr(p_stm_id okl_strm_elements.stm_id%TYPE) IS

570: -- AND sgn_code <> 'INTC' -- bug 4737555
571: AND sgn_code NOT IN ('INTC','LATE_CALC') -- Bug 6472228
572: AND NVL(purpose_code,'XXXX') = NVL(p_purpose_code, 'XXXX');
573:
574: CURSOR strm_element_csr(p_stm_id okl_strm_elements.stm_id%TYPE) IS
575: SELECT *
576: FROM okl_strm_elements
577: WHERE stm_id = p_stm_id;
578:

Line 576: FROM okl_strm_elements

572: AND NVL(purpose_code,'XXXX') = NVL(p_purpose_code, 'XXXX');
573:
574: CURSOR strm_element_csr(p_stm_id okl_strm_elements.stm_id%TYPE) IS
575: SELECT *
576: FROM okl_strm_elements
577: WHERE stm_id = p_stm_id;
578:
579: CURSOR orig_line_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
580: SELECT orig_system_id1

Line 592: FROM okl_strm_elements ele,

588:
589: CURSOR unbill_adj_csr( khrId NUMBER,
590: kleid NUMBER ) IS
591: SELECT NVL(ele.amount,0) amount
592: FROM okl_strm_elements ele,
593: okl_streams str,
594: --okl_strm_type_tl sty
595: okl_strm_type_v sty
596: WHERE NVL(str.kle_id,-1) = kleid

Line 610: FROM okl_strm_elements ele,

606:
607: CURSOR undesb_adj_csr( khrId NUMBER,
608: kleid NUMBER ) IS
609: SELECT NVL(ele.amount,0) amount
610: FROM okl_strm_elements ele,
611: okl_streams str,
612: --okl_strm_type_tl sty
613: okl_strm_type_v sty
614: WHERE NVL(str.kle_id,-1) = kleid

Line 672: FROM okl_strm_elements sel

668: --Bug# 4212626
669: -- Cursor to determine if Stream is billed
670: CURSOR stm_not_billed_csr(p_stm_id IN NUMBER) IS
671: SELECT 1
672: FROM okl_strm_elements sel
673: WHERE sel.stm_id = p_stm_id
674: AND sel.date_billed IS NULL
675: AND rownum = 1;
676:

Line 7072: FROM okl_strm_elements sel

7068: AND pph.passthru_term = 'BASE';
7069:
7070: CURSOR max_disb_date_csr(p_stm_id IN NUMBER) IS
7071: SELECT MAX(sel.stream_element_date) stream_element_date
7072: FROM okl_strm_elements sel
7073: WHERE sel.stm_id = p_stm_id
7074: AND sel.date_disbursed IS NOT NULL;
7075:
7076: CURSOR actual_amount_disb_csr(p_stm_id IN NUMBER) IS

Line 7078: FROM okl_strm_elements sel

7074: AND sel.date_disbursed IS NOT NULL;
7075:
7076: CURSOR actual_amount_disb_csr(p_stm_id IN NUMBER) IS
7077: SELECT NVL(SUM(sel.amount),0) amount
7078: FROM okl_strm_elements sel
7079: WHERE sel.stm_id = p_stm_id
7080: AND sel.date_disbursed IS NOT NULL;
7081:
7082: CURSOR amount_to_be_disb_csr(p_stm_id IN NUMBER,

Line 7086: FROM okl_strm_elements sel

7082: CURSOR amount_to_be_disb_csr(p_stm_id IN NUMBER,
7083: p_max_disb_date IN DATE) IS
7084: SELECT sel.id sel_id,
7085: NVL(sel.amount,0) amount
7086: FROM okl_strm_elements sel
7087: WHERE sel.stm_id = p_stm_id
7088: AND sel.stream_element_date <= p_max_disb_date;
7089:
7090: -- Cursor to fetch Streams deleted during rebook

Line 7424: FROM okl_strm_elements sel

7420: AND orig_stm.id = new_stm.link_hist_stream_id;
7421:
7422: CURSOR max_bill_date_csr(p_stm_id IN NUMBER) IS
7423: SELECT MAX(sel.stream_element_date) stream_element_date
7424: FROM okl_strm_elements sel
7425: WHERE sel.stm_id = p_stm_id
7426: AND sel.date_billed IS NOT NULL;
7427:
7428: CURSOR actual_amount_billed_csr(p_stm_id IN NUMBER) IS

Line 7430: FROM okl_strm_elements sel

7426: AND sel.date_billed IS NOT NULL;
7427:
7428: CURSOR actual_amount_billed_csr(p_stm_id IN NUMBER) IS
7429: SELECT NVL(SUM(sel.amount),0) amount
7430: FROM okl_strm_elements sel
7431: WHERE sel.stm_id = p_stm_id
7432: AND sel.date_billed IS NOT NULL;
7433:
7434: CURSOR amount_to_be_billed_csr(p_stm_id IN NUMBER,

Line 7438: FROM okl_strm_elements sel

7434: CURSOR amount_to_be_billed_csr(p_stm_id IN NUMBER,
7435: p_max_bill_date IN DATE) IS
7436: SELECT sel.id sel_id,
7437: NVL(sel.amount,0) amount
7438: FROM okl_strm_elements sel
7439: WHERE sel.stm_id = p_stm_id
7440: AND sel.stream_element_date <= p_max_bill_date;
7441:
7442: -- Cursor to fetch Streams deleted during rebook

Line 7822: FROM okl_strm_elements sel

7818: AND styt.language = USERENV('LANG');
7819:
7820: CURSOR max_accrual_date_csr(p_stm_id IN NUMBER) IS
7821: SELECT MAX(sel.stream_element_date) stream_element_date
7822: FROM okl_strm_elements sel
7823: WHERE sel.stm_id = p_stm_id
7824: AND sel.accrued_yn IS NOT NULL;
7825:
7826: CURSOR actual_amount_accrued_csr(p_stm_id IN NUMBER) IS

Line 7828: FROM okl_strm_elements sel

7824: AND sel.accrued_yn IS NOT NULL;
7825:
7826: CURSOR actual_amount_accrued_csr(p_stm_id IN NUMBER) IS
7827: SELECT NVL(SUM(sel.amount),0) amount
7828: FROM okl_strm_elements sel
7829: WHERE sel.stm_id = p_stm_id
7830: AND sel.accrued_yn IS NOT NULL;
7831:
7832: CURSOR amount_to_be_accrued_csr(p_stm_id IN NUMBER,

Line 7836: FROM okl_strm_elements sel

7832: CURSOR amount_to_be_accrued_csr(p_stm_id IN NUMBER,
7833: p_max_accrual_date IN DATE) IS
7834: SELECT sel.id sel_id,
7835: NVL(sel.amount,0) amount
7836: FROM okl_strm_elements sel
7837: WHERE sel.stm_id = p_stm_id
7838: AND sel.stream_element_date <= p_max_accrual_date;
7839:
7840: -- Cursor to fetch Streams deleted during rebook

Line 8181: FROM okl_strm_elements sel

8177: 'INVESTOR_VARIABLE_INTEREST');
8178:
8179: CURSOR max_accrual_date_csr(p_stm_id IN NUMBER) IS
8180: SELECT MAX(sel.stream_element_date) stream_element_date
8181: FROM okl_strm_elements sel
8182: WHERE sel.stm_id = p_stm_id
8183: AND sel.accrued_yn IS NOT NULL;
8184:
8185: CURSOR actual_amount_accrued_csr(p_stm_id IN NUMBER) IS

Line 8187: FROM okl_strm_elements sel

8183: AND sel.accrued_yn IS NOT NULL;
8184:
8185: CURSOR actual_amount_accrued_csr(p_stm_id IN NUMBER) IS
8186: SELECT NVL(SUM(sel.amount),0) amount
8187: FROM okl_strm_elements sel
8188: WHERE sel.stm_id = p_stm_id
8189: AND sel.accrued_yn IS NOT NULL;
8190:
8191: CURSOR amount_to_be_accrued_csr(p_stm_id IN NUMBER,

Line 8195: FROM okl_strm_elements sel

8191: CURSOR amount_to_be_accrued_csr(p_stm_id IN NUMBER,
8192: p_max_accrual_date IN DATE) IS
8193: SELECT sel.id sel_id,
8194: NVL(sel.amount,0) amount
8195: FROM okl_strm_elements sel
8196: WHERE sel.stm_id = p_stm_id
8197: AND sel.stream_element_date <= p_max_accrual_date;
8198:
8199: -- Cursor to fetch Streams deleted during rebook

Line 8589: FROM okl_strm_elements inv_sel,

8585: AND orig_stm.id = new_stm.link_hist_stream_id;
8586:
8587: CURSOR actual_amount_disb_csr(p_stm_id IN NUMBER) IS
8588: SELECT NVL(SUM(inv_sel.amount),0) amount
8589: FROM okl_strm_elements inv_sel,
8590: okl_strm_elements sel
8591: WHERE sel.stm_id = p_stm_id
8592: AND sel.date_billed IS NOT NULL
8593: AND inv_sel.sel_id = sel.id;

Line 8590: okl_strm_elements sel

8586:
8587: CURSOR actual_amount_disb_csr(p_stm_id IN NUMBER) IS
8588: SELECT NVL(SUM(inv_sel.amount),0) amount
8589: FROM okl_strm_elements inv_sel,
8590: okl_strm_elements sel
8591: WHERE sel.stm_id = p_stm_id
8592: AND sel.date_billed IS NOT NULL
8593: AND inv_sel.sel_id = sel.id;
8594:

Line 8598: FROM okl_strm_elements inv_sel,

8594:
8595: CURSOR amount_to_be_disb_csr(p_stm_id IN NUMBER) IS
8596: SELECT inv_sel.id sel_id,
8597: NVL(inv_sel.amount,0) amount
8598: FROM okl_strm_elements inv_sel,
8599: okl_strm_elements sel
8600: WHERE sel.stm_id = p_stm_id
8601: AND sel.date_billed IS NOT NULL
8602: AND inv_sel.sel_id = sel.id;

Line 8599: okl_strm_elements sel

8595: CURSOR amount_to_be_disb_csr(p_stm_id IN NUMBER) IS
8596: SELECT inv_sel.id sel_id,
8597: NVL(inv_sel.amount,0) amount
8598: FROM okl_strm_elements inv_sel,
8599: okl_strm_elements sel
8600: WHERE sel.stm_id = p_stm_id
8601: AND sel.date_billed IS NOT NULL
8602: AND inv_sel.sel_id = sel.id;
8603:

Line 8657: FROM okl_strm_elements sel

8653:
8654: CURSOR undisb_adj_amt_csr(p_stm_id NUMBER)
8655: IS
8656: SELECT NVL(SUM(sel.AMOUNT),0) amount
8657: FROM okl_strm_elements sel
8658: WHERE sel.stm_id = p_stm_id
8659: AND sel.date_billed IS NULL;
8660:
8661: l_undisb_adj_amt_rec undisb_adj_amt_csr%ROWTYPE;

Line 8666: FROM okl_strm_elements sel

8662:
8663: CURSOR chk_old_adj_disb_csr(p_stm_id NUMBER)
8664: IS
8665: SELECT 'Y'
8666: FROM okl_strm_elements sel
8667: WHERE sel.stm_id = p_stm_id
8668: AND sel.date_billed IS NULL;
8669:
8670: l_undisb_adj_exists VARCHAR2(30);

Line 9326: FROM okl_strm_elements sel

9322: 'INVESTOR_VARIABLE_INTEREST');
9323:
9324: CURSOR max_accrual_date_csr(p_stm_id IN NUMBER) IS
9325: SELECT MAX(sel.stream_element_date) stream_element_date
9326: FROM okl_strm_elements sel
9327: WHERE sel.stm_id = p_stm_id
9328: AND sel.accrued_yn IS NOT NULL;
9329:
9330: CURSOR actual_amount_accrued_csr(p_stm_id IN NUMBER) IS

Line 9332: FROM okl_strm_elements sel

9328: AND sel.accrued_yn IS NOT NULL;
9329:
9330: CURSOR actual_amount_accrued_csr(p_stm_id IN NUMBER) IS
9331: SELECT NVL(SUM(sel.amount),0) amount
9332: FROM okl_strm_elements sel
9333: WHERE sel.stm_id = p_stm_id
9334: AND sel.accrued_yn IS NOT NULL;
9335:
9336: CURSOR amount_to_be_accrued_csr(p_stm_id IN NUMBER,

Line 9340: FROM okl_strm_elements sel

9336: CURSOR amount_to_be_accrued_csr(p_stm_id IN NUMBER,
9337: p_max_accrual_date IN DATE) IS
9338: SELECT sel.id sel_id,
9339: NVL(sel.amount,0) amount
9340: FROM okl_strm_elements sel
9341: WHERE sel.stm_id = p_stm_id
9342: AND sel.stream_element_date <= p_max_accrual_date;
9343:
9344: l_max_accrual_date DATE;