APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKL_STRM_TYPE_V

Line 553: okl_strm_type_v sty

549: trx_id,
550: link_hist_stream_id
551: -- sty_code -- dropped after inclusion
552: FROM okl_streams str,
553: okl_strm_type_v sty
554: WHERE str.khr_id = p_rebook_chr_id
555: AND str.sty_id = sty.id
556: AND str.say_code = 'CURR';
557:

Line 595: okl_strm_type_v sty

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
597: AND str.khr_id = khrId
598: AND str.sty_id = sty.id
599: AND str.say_code = 'CURR'

Line 613: okl_strm_type_v sty

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
615: AND str.khr_id = khrId
616: AND str.sty_id = sty.id
617: AND str.say_code = 'CURR'

Line 628: FROM okl_strm_type_v

624:
625: /* not required after UDS
626: CURSOR strm_code_csr (p_sty_id NUMBER) IS
627: SELECT code
628: FROM okl_strm_type_v
629: WHERE id = p_sty_id;
630: */
631:
632: l_orig_line_id OKC_K_LINES_B.ID%TYPE;

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

634: l_orig_strm_tbl stmv_tbl_type;
635: x_orig_strm_tbl stmv_tbl_type;
636:
637: l_orig_strm_count NUMBER := 0;
638: --l_strm_code OKL_STRM_TYPE_V.CODE%TYPE;
639: l_unbill_adj_amount NUMBER := 0;
640: l_undesb_adj_amount NUMBER := 0;
641:
642: x_billing_adj_sty_id NUMBER;

Line 654: okl_strm_type_v sty

650: sty.stream_type_purpose,
651: cle.lse_id
652: FROM okl_streams orig_stm,
653: okc_k_lines_b cle,
654: okl_strm_type_v sty
655: WHERE orig_stm.khr_id = p_orig_chr_id
656: AND orig_stm.say_code = 'CURR'
657: --AND orig_stm.sgn_code <> 'INTC' -- bug 4737555
658: AND orig_stm.sgn_code NOT IN ('INTC','LATE_CALC') -- Bug6472228

Line 5849: okl_strm_type_v TYPE

5845:
5846: CURSOR disb_strm_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
5847: SELECT strm.id
5848: FROM okl_streams strm,
5849: okl_strm_type_v TYPE
5850: WHERE TYPE.id = strm.sty_id
5851: AND TYPE.stream_type_subclass = 'INVESTOR_DISBURSEMENT'
5852: AND strm.khr_id = p_chr_id
5853: AND strm.say_code = 'CURR';

Line 5858: okl_strm_type_v TYPE

5854:
5855: CURSOR accu_strm_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
5856: SELECT strm.id
5857: FROM okl_streams strm,
5858: okl_strm_type_v TYPE
5859: WHERE TYPE.id = strm.sty_id
5860: /*
5861: AND TYPE.name IN (
5862: 'INVESTOR RENTAL ACCRUAL',

Line 8161: okl_strm_type_v sty

8157: okl_prod_strm_types psty,
8158: okl_k_headers khr,
8159: --okl_streams orig_stm,
8160: okl_streams_rep_v orig_stm, -- MGAAP 7263041
8161: okl_strm_type_v sty
8162: WHERE khr.id = p_khr_id
8163: --AND psty.pdt_id = khr.pdt_id
8164: AND psty.pdt_id = DECODE(OKL_STREAMS_SEC_PVT.GET_STREAMS_POLICY,
8165: 'PRIMARY', khr.pdt_id, p_reporting_pdt_id) -- MGAAP 7263041

Line 8213: okl_strm_type_v sty

8209: FROM okl_streams_rep_v orig_stm, -- MGAAP 7263041
8210: okl_prod_strm_types psty,
8211: okl_k_headers khr,
8212: okc_k_lines_b cle,
8213: okl_strm_type_v sty
8214: WHERE khr.id = p_orig_khr_id
8215: --AND psty.pdt_id = khr.pdt_id
8216: AND psty.pdt_id = DECODE(OKL_STREAMS_SEC_PVT.GET_STREAMS_POLICY,
8217: 'PRIMARY', khr.pdt_id, p_reporting_pdt_id) -- MGAAP 7263041

Line 9308: okl_strm_type_v sty

9304: okl_prod_strm_types psty,
9305: okl_k_headers khr,
9306: --okl_streams orig_stm,
9307: okl_streams_rep_v orig_stm, -- MGAAP 7263041
9308: okl_strm_type_v sty
9309: WHERE khr.id = p_khr_id
9310: --AND psty.pdt_id = khr.pdt_id
9311: AND psty.pdt_id = NVL(p_product_id, khr.pdt_id) -- MGAAP 7263041
9312: AND psty.accrual_yn = 'Y'