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 4807: okl_strm_type_tl sty

4803: Cursor l_strms_csr ( chrId NUMBER, st VARCHAR2 ) IS
4804: Select sty.id sty_id,
4805: sty.name
4806: From okl_streams str,
4807: okl_strm_type_tl sty
4808: Where sty.id = str.sty_id
4809: and str.khr_id = chrId
4810: and sty.name = st
4811: and sty.language = 'US'

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

5048: WHERE khr.id = chr.id
5049: AND chr.id = chrId
5050: AND khr.pdt_id = pdt.id(+);
5051: -- Get the Stream id
5052: CURSOR get_styid_csr(p_strm_name OKL_STRM_TYPE_TL.NAME%TYPE)
5053: IS
5054: SELECT nvl(tl.id,-1) id,
5055: b.stream_type_subclass
5056: FROM okl_strm_type_tl tl,

Line 5056: FROM okl_strm_type_tl tl,

5052: CURSOR get_styid_csr(p_strm_name OKL_STRM_TYPE_TL.NAME%TYPE)
5053: IS
5054: SELECT nvl(tl.id,-1) id,
5055: b.stream_type_subclass
5056: FROM okl_strm_type_tl tl,
5057: okl_strm_type_b b
5058: WHERE tl.language = USERENV('LANG')
5059: AND tl.name = p_strm_name
5060: AND tl.id = b.id;

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

5625: AND lse.lty_code in ( 'FREE_FORM1', 'FEE', 'SOLD_SERVICE', 'LINK_SERV_ASSET')--bug# 3343133 (ssiruvol)
5626: AND kle.dnz_chr_id = p_chr_id;
5627:
5628: -- Get the Stream id
5629: CURSOR get_styid_csr(p_strm_name OKL_STRM_TYPE_TL.NAME%TYPE)
5630: IS
5631: SELECT nvl(tl.id,-1) id,
5632: b.stream_type_subclass
5633: FROM okl_strm_type_tl tl,

Line 5633: FROM okl_strm_type_tl tl,

5629: CURSOR get_styid_csr(p_strm_name OKL_STRM_TYPE_TL.NAME%TYPE)
5630: IS
5631: SELECT nvl(tl.id,-1) id,
5632: b.stream_type_subclass
5633: FROM okl_strm_type_tl tl,
5634: okl_strm_type_b b
5635: WHERE tl.language = USERENV('LANG')
5636: AND tl.name = p_strm_name
5637: AND tl.id = b.id;

Line 9595: okl_strm_type_tl tl

9591: tl.description alloc_basis,
9592: stm.capitalize_yn capitalize_yn,
9593: stm.periodic_yn periodic_yn
9594: FROM okl_strm_type_b stm,
9595: okl_strm_type_tl tl
9596: WHERE tl.id = stm.id
9597: AND tl.language = 'US'
9598: AND stm.id = styid;
9599: --get finance strms

Line 9607: FROM okl_strm_type_tl

9603: -- Get the stream type id
9604: CURSOR l_strmid_csr (strmName VARCHAR2)
9605: IS
9606: SELECT id styid
9607: FROM okl_strm_type_tl
9608: WHERE LANGUAGE = 'US'
9609: AND NAME = strmName;
9610: -- get the Contract line info
9611: CURSOR l_line_rec_csr(chrid NUMBER)

Line 11063: FROM okl_strm_type_tl styt,

11059: p_cle_id NUMBER )
11060: IS
11061: SELECT crl.rule_information2 amount,
11062: styt.name strm_name
11063: FROM okl_strm_type_tl styt,
11064: okc_k_items cim,
11065: okc_rule_groups_b crg,
11066: okc_rules_b crl
11067: WHERE crl.rgp_id = crg.id

Line 11114: FROM okl_strm_type_tl styt,

11110: SELECT kle.amount amount,
11111: styt.name strm_name,
11112: kle.fee_purpose_code fee_purpose_code,
11113: styt.id sty_id
11114: FROM okl_strm_type_tl styt,
11115: okc_k_items cim,
11116: okc_k_lines_b cle,
11117: okl_k_lines kle
11118: WHERE cle.dnz_chr_id = p_chr_d

Line 20234: FROM okl_strm_type_tl

20230: -- Get the stream type id
20231: CURSOR l_strmid_csr_lease (strmName VARCHAR2)
20232: IS
20233: SELECT id styid
20234: FROM okl_strm_type_tl
20235: WHERE LANGUAGE = 'US'
20236: AND NAME = strmName;
20237:
20238: --Added capital_reduction_percent by bkatraga for bug 15942693

Line 20352: okl_strm_type_tl tl

20348: tl.description alloc_basis,
20349: stm.capitalize_yn capitalize_yn,
20350: stm.periodic_yn periodic_yn
20351: FROM okl_strm_type_b stm,
20352: okl_strm_type_tl tl
20353: WHERE tl.id = stm.id
20354: AND tl.language = 'US'
20355: AND stm.id = styid;
20356: -- get the self referencing Line based rule information

Line 24897: FROM okl_strm_type_tl

24893: -- Get the stream type id
24894: CURSOR l_strmid_csr (strmName VARCHAR2)
24895: IS
24896: SELECT id styid
24897: FROM okl_strm_type_tl
24898: WHERE LANGUAGE = 'US'
24899: AND NAME = strmName;
24900: -- get Stream name
24901: CURSOR strm_name_csr (styid NUMBER)

Line 24910: okl_strm_type_tl tl

24906: tl.description alloc_basis,
24907: stm.capitalize_yn capitalize_yn,
24908: stm.periodic_yn periodic_yn
24909: FROM okl_strm_type_b stm,
24910: okl_strm_type_tl tl
24911: WHERE tl.id = stm.id
24912: AND tl.language = 'US'
24913: AND stm.id = styid;
24914: -- get the LASLH self referencing Line based rule information

Line 25242: FROM okl_strm_type_tl

25238: END IF;
25239: /*
25240: SELECT nvl(id,-1)
25241: INTO styid
25242: FROM okl_strm_type_tl
25243: WHERE LANGUAGE = 'US'
25244: AND name = 'RESIDUAL VALUE INSURANCE PREMIUM';
25245: IF styid = -1 THEN
25246: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;