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_LA_STREAM_PVT dependencies on OKL_STRM_TYPE_TL

Line 3709: okl_strm_type_tl sty

3705: Cursor l_strms_csr ( chrId NUMBER, st VARCHAR2 ) IS
3706: Select sty.id sty_id,
3707: sty.name
3708: From okl_streams str,
3709: okl_strm_type_tl sty
3710: Where sty.id = str.sty_id
3711: and str.khr_id = chrId
3712: and sty.name = st
3713: and sty.language = 'US'

Line 3953: CURSOR get_styid_csr(p_strm_name OKL_STRM_TYPE_TL.NAME%TYPE)

3949: WHERE khr.id = chr.id
3950: AND chr.id = chrId
3951: AND khr.pdt_id = pdt.id(+);
3952: -- Get the Stream id
3953: CURSOR get_styid_csr(p_strm_name OKL_STRM_TYPE_TL.NAME%TYPE)
3954: IS
3955: SELECT nvl(tl.id,-1) id,
3956: b.stream_type_subclass
3957: FROM okl_strm_type_tl tl,

Line 3957: FROM okl_strm_type_tl tl,

3953: CURSOR get_styid_csr(p_strm_name OKL_STRM_TYPE_TL.NAME%TYPE)
3954: IS
3955: SELECT nvl(tl.id,-1) id,
3956: b.stream_type_subclass
3957: FROM okl_strm_type_tl tl,
3958: okl_strm_type_b b
3959: WHERE tl.language = USERENV('LANG')
3960: AND tl.name = p_strm_name
3961: AND tl.id = b.id;

Line 4530: CURSOR get_styid_csr(p_strm_name OKL_STRM_TYPE_TL.NAME%TYPE)

4526: AND lse.lty_code in ( 'FREE_FORM1', 'FEE', 'SOLD_SERVICE', 'LINK_SERV_ASSET')--bug# 3343133 (ssiruvol)
4527: AND kle.dnz_chr_id = p_chr_id;
4528:
4529: -- Get the Stream id
4530: CURSOR get_styid_csr(p_strm_name OKL_STRM_TYPE_TL.NAME%TYPE)
4531: IS
4532: SELECT nvl(tl.id,-1) id,
4533: b.stream_type_subclass
4534: FROM okl_strm_type_tl tl,

Line 4534: FROM okl_strm_type_tl tl,

4530: CURSOR get_styid_csr(p_strm_name OKL_STRM_TYPE_TL.NAME%TYPE)
4531: IS
4532: SELECT nvl(tl.id,-1) id,
4533: b.stream_type_subclass
4534: FROM okl_strm_type_tl tl,
4535: okl_strm_type_b b
4536: WHERE tl.language = USERENV('LANG')
4537: AND tl.name = p_strm_name
4538: AND tl.id = b.id;

Line 8075: okl_strm_type_tl tl

8071: tl.description alloc_basis,
8072: stm.capitalize_yn capitalize_yn,
8073: stm.periodic_yn periodic_yn
8074: FROM okl_strm_type_b stm,
8075: okl_strm_type_tl tl
8076: WHERE tl.id = stm.id
8077: AND tl.language = 'US'
8078: AND stm.id = styid;
8079: --get finance strms

Line 8087: FROM okl_strm_type_tl

8083: -- Get the stream type id
8084: CURSOR l_strmid_csr (strmName VARCHAR2)
8085: IS
8086: SELECT id styid
8087: FROM okl_strm_type_tl
8088: WHERE LANGUAGE = 'US'
8089: AND NAME = strmName;
8090: -- get the Contract line info
8091: CURSOR l_line_rec_csr(chrid NUMBER)

Line 9477: FROM okl_strm_type_tl styt,

9473: p_cle_id NUMBER )
9474: IS
9475: SELECT crl.rule_information2 amount,
9476: styt.name strm_name
9477: FROM okl_strm_type_tl styt,
9478: okc_k_items cim,
9479: okc_rule_groups_b crg,
9480: okc_rules_b crl
9481: WHERE crl.rgp_id = crg.id

Line 9526: FROM okl_strm_type_tl styt,

9522: SELECT kle.amount amount,
9523: styt.name strm_name,
9524: kle.fee_purpose_code fee_purpose_code,
9525: styt.id sty_id
9526: FROM okl_strm_type_tl styt,
9527: okc_k_items cim,
9528: okc_k_lines_b cle,
9529: okl_k_lines kle
9530: WHERE cle.dnz_chr_id = p_chr_d

Line 17600: FROM okl_strm_type_tl

17596: -- Get the stream type id
17597: CURSOR l_strmid_csr_lease (strmName VARCHAR2)
17598: IS
17599: SELECT id styid
17600: FROM okl_strm_type_tl
17601: WHERE LANGUAGE = 'US'
17602: AND NAME = strmName;
17603: -- get the lease Contract line info
17604: -- Modified by kthiruva on 26-Aug-05

Line 17714: okl_strm_type_tl tl

17710: tl.description alloc_basis,
17711: stm.capitalize_yn capitalize_yn,
17712: stm.periodic_yn periodic_yn
17713: FROM okl_strm_type_b stm,
17714: okl_strm_type_tl tl
17715: WHERE tl.id = stm.id
17716: AND tl.language = 'US'
17717: AND stm.id = styid;
17718: -- get the self referencing Line based rule information

Line 22054: FROM okl_strm_type_tl

22050: -- Get the stream type id
22051: CURSOR l_strmid_csr (strmName VARCHAR2)
22052: IS
22053: SELECT id styid
22054: FROM okl_strm_type_tl
22055: WHERE LANGUAGE = 'US'
22056: AND NAME = strmName;
22057: -- get Stream name
22058: CURSOR strm_name_csr (styid NUMBER)

Line 22067: okl_strm_type_tl tl

22063: tl.description alloc_basis,
22064: stm.capitalize_yn capitalize_yn,
22065: stm.periodic_yn periodic_yn
22066: FROM okl_strm_type_b stm,
22067: okl_strm_type_tl tl
22068: WHERE tl.id = stm.id
22069: AND tl.language = 'US'
22070: AND stm.id = styid;
22071: -- get the LASLH self referencing Line based rule information

Line 22399: FROM okl_strm_type_tl

22395: END IF;
22396: /*
22397: SELECT nvl(id,-1)
22398: INTO styid
22399: FROM okl_strm_type_tl
22400: WHERE LANGUAGE = 'US'
22401: AND name = 'RESIDUAL VALUE INSURANCE PREMIUM';
22402: IF styid = -1 THEN
22403: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;