APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKL_STRM_TYPE_V

Line 582: okl_strm_type_v sty

578: trx_id,
579: link_hist_stream_id
580: -- sty_code -- dropped after inclusion
581: FROM okl_streams str,
582: okl_strm_type_v sty
583: WHERE str.khr_id = p_rebook_chr_id
584: AND str.sty_id = sty.id
585: AND str.say_code = 'CURR';
586:

Line 624: okl_strm_type_v sty

620: SELECT NVL(ele.amount,0) amount
621: FROM okl_strm_elements ele,
622: okl_streams str,
623: --okl_strm_type_tl sty
624: okl_strm_type_v sty
625: WHERE NVL(str.kle_id,-1) = kleid
626: AND str.khr_id = khrId
627: AND str.sty_id = sty.id
628: AND str.say_code = 'CURR'

Line 642: okl_strm_type_v sty

638: SELECT NVL(ele.amount,0) amount
639: FROM okl_strm_elements ele,
640: okl_streams str,
641: --okl_strm_type_tl sty
642: okl_strm_type_v sty
643: WHERE NVL(str.kle_id,-1) = kleid
644: AND str.khr_id = khrId
645: AND str.sty_id = sty.id
646: AND str.say_code = 'CURR'

Line 657: FROM okl_strm_type_v

653:
654: /* not required after UDS
655: CURSOR strm_code_csr (p_sty_id NUMBER) IS
656: SELECT code
657: FROM okl_strm_type_v
658: WHERE id = p_sty_id;
659: */
660:
661: l_orig_line_id OKC_K_LINES_B.ID%TYPE;

Line 667: --l_strm_code OKL_STRM_TYPE_V.CODE%TYPE;

663: l_orig_strm_tbl stmv_tbl_type;
664: x_orig_strm_tbl stmv_tbl_type;
665:
666: l_orig_strm_count NUMBER := 0;
667: --l_strm_code OKL_STRM_TYPE_V.CODE%TYPE;
668: l_unbill_adj_amount NUMBER := 0;
669: l_undesb_adj_amount NUMBER := 0;
670:
671: x_billing_adj_sty_id NUMBER;

Line 683: okl_strm_type_v sty

679: sty.stream_type_purpose,
680: cle.lse_id
681: FROM okl_streams orig_stm,
682: okc_k_lines_b cle,
683: okl_strm_type_v sty
684: WHERE orig_stm.khr_id = p_orig_chr_id
685: AND orig_stm.say_code = 'CURR'
686: --AND orig_stm.sgn_code <> 'INTC' -- bug 4737555
687: AND orig_stm.sgn_code NOT IN ('INTC','LATE_CALC') -- Bug6472228

Line 7510: okl_strm_type_v TYPE

7506:
7507: CURSOR disb_strm_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
7508: SELECT strm.id
7509: FROM okl_streams strm,
7510: okl_strm_type_v TYPE
7511: WHERE TYPE.id = strm.sty_id
7512: AND TYPE.stream_type_subclass = 'INVESTOR_DISBURSEMENT'
7513: AND strm.khr_id = p_chr_id
7514: AND strm.say_code = 'CURR';

Line 7519: okl_strm_type_v TYPE

7515:
7516: CURSOR accu_strm_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
7517: SELECT strm.id
7518: FROM okl_streams strm,
7519: okl_strm_type_v TYPE
7520: WHERE TYPE.id = strm.sty_id
7521: /*
7522: AND TYPE.name IN (
7523: 'INVESTOR RENTAL ACCRUAL',

Line 9835: okl_strm_type_v sty

9831: okl_prod_strm_types psty,
9832: okl_k_headers khr,
9833: --okl_streams orig_stm,
9834: okl_streams_rep_v orig_stm, -- MGAAP 7263041
9835: okl_strm_type_v sty
9836: WHERE khr.id = p_khr_id
9837: --AND psty.pdt_id = khr.pdt_id
9838: AND psty.pdt_id = DECODE(OKL_STREAMS_SEC_PVT.GET_STREAMS_POLICY,
9839: 'PRIMARY', khr.pdt_id, p_reporting_pdt_id) -- MGAAP 7263041

Line 9887: okl_strm_type_v sty

9883: FROM okl_streams_rep_v orig_stm, -- MGAAP 7263041
9884: okl_prod_strm_types psty,
9885: okl_k_headers khr,
9886: okc_k_lines_b cle,
9887: okl_strm_type_v sty
9888: WHERE khr.id = p_orig_khr_id
9889: --AND psty.pdt_id = khr.pdt_id
9890: AND psty.pdt_id = DECODE(OKL_STREAMS_SEC_PVT.GET_STREAMS_POLICY,
9891: 'PRIMARY', khr.pdt_id, p_reporting_pdt_id) -- MGAAP 7263041

Line 11179: okl_strm_type_v sty

11175: okl_prod_strm_types psty,
11176: okl_k_headers khr,
11177: --okl_streams orig_stm,
11178: okl_streams_rep_v orig_stm, -- MGAAP 7263041
11179: okl_strm_type_v sty
11180: WHERE khr.id = p_khr_id
11181: --AND psty.pdt_id = khr.pdt_id
11182: AND psty.pdt_id = NVL(p_product_id, khr.pdt_id) -- MGAAP 7263041
11183: AND psty.accrual_yn = 'Y'