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_B

Line 110: p_sty_id IN okl_strm_type_b.ID%TYPE,

106: -- Added new procedure for get the streams for reporting and original product
107: PROCEDURE get_primary_pricing_name
108: (
109: p_khr_id IN okl_k_headers_full_v.id%TYPE,
110: p_sty_id IN okl_strm_type_b.ID%TYPE,
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_primary_pricing_name OUT NOCOPY OKL_ST_GEN_TMPT_LNS.PRICING_NAME%TYPE
113: )
114:

Line 133: FROM okl_strm_type_b

129: AND PRIMARY_STY_ID = p_sty_id;
130:
131: CURSOR sty_csr IS
132: SELECT CODE
133: FROM okl_strm_type_b
134: WHERE id = p_sty_id;
135:
136:
137: -- l_primary_pricing_name VARCHAR2(30); --02-Sep-11 SECHAWLA 12936702

Line 142: l_sty_code okl_strm_type_b.code%TYPE;

138: l_primary_pricing_name VARCHAR2(150); --02-Sep-11 SECHAWLA 12936702
139:
140: l_contract_start_date DATE;
141: l_product_id NUMBER;
142: l_sty_code okl_strm_type_b.code%TYPE;
143:
144: BEGIN
145:
146: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 218: p_sty_id IN okl_strm_type_b.ID%TYPE,

214:
215: PROCEDURE get_dependent_pricing_name
216: (
217: p_khr_id IN okl_k_headers_full_v.id%TYPE,
218: p_sty_id IN okl_strm_type_b.ID%TYPE,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_dependent_pricing_name OUT NOCOPY OKL_ST_GEN_TMPT_LNS.PRICING_NAME%TYPE
221: )
222:

Line 242: FROM okl_strm_type_b

238: AND PRICING_NAME IS NOT NULL;
239:
240: CURSOR sty_csr IS
241: SELECT CODE
242: FROM okl_strm_type_b
243: WHERE id = p_sty_id;
244:
245: -- l_dependent_pricing_name VARCHAR2(40); --02-Sep-11 SECHAWLA 12936702
246: l_dependent_pricing_name VARCHAR2(150); --02-Sep-11 SECHAWLA 12936702

Line 250: l_sty_code okl_strm_type_b.code%TYPE;

246: l_dependent_pricing_name VARCHAR2(150); --02-Sep-11 SECHAWLA 12936702
247:
248: l_contract_start_date DATE;
249: l_product_id NUMBER;
250: l_sty_code okl_strm_type_b.code%TYPE;
251:
252: BEGIN
253:
254: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 328: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

324:
325: PROCEDURE get_primary_stream_type
326: (
327: p_khr_id IN okl_k_headers_full_v.id%TYPE,
328: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
329: x_return_status OUT NOCOPY VARCHAR2,
330: x_primary_sty_id OUT NOCOPY strm_rec_type
331: )
332:

Line 431: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

427: PROCEDURE get_primary_no_prc_stream_type
428: (
429: p_khr_id IN okl_k_headers_full_v.id%TYPE,
430: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
431: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
432: x_return_status OUT NOCOPY VARCHAR2,
433: x_primary_sty_id OUT NOCOPY strm_rec_type
434: )
435:

Line 536: p_primary_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,

532: PROCEDURE get_dep_no_prc_stream_type
533: (
534: p_khr_id IN okl_k_headers_full_v.id%TYPE,
535: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
536: p_primary_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
537: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
538: x_return_status OUT NOCOPY VARCHAR2,
539: x_dependent_sty_id OUT NOCOPY strm_rec_type
540: )

Line 537: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,

533: (
534: p_khr_id IN okl_k_headers_full_v.id%TYPE,
535: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
536: p_primary_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
537: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
538: x_return_status OUT NOCOPY VARCHAR2,
539: x_dependent_sty_id OUT NOCOPY strm_rec_type
540: )
541:

Line 640: p_primary_sty_id IN okl_strm_type_b.id%TYPE,

636: PROCEDURE get_dep_no_prc_stream_type
637: (
638: p_khr_id IN okl_k_headers_full_v.id%TYPE,
639: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
640: p_primary_sty_id IN okl_strm_type_b.id%TYPE,
641: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
642: x_return_status OUT NOCOPY VARCHAR2,
643: x_dependent_sty_id OUT NOCOPY strm_rec_type
644: )

Line 641: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,

637: (
638: p_khr_id IN okl_k_headers_full_v.id%TYPE,
639: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
640: p_primary_sty_id IN okl_strm_type_b.id%TYPE,
641: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
642: x_return_status OUT NOCOPY VARCHAR2,
643: x_dependent_sty_id OUT NOCOPY strm_rec_type
644: )
645:

Line 741: p_primary_sty_id IN okl_strm_type_b.id%TYPE,

737:
738: PROCEDURE get_dep_no_prc_stream_type
739: (
740: p_khr_id IN okl_k_headers_full_v.id%TYPE,
741: p_primary_sty_id IN okl_strm_type_b.id%TYPE,
742: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
743: x_return_status OUT NOCOPY VARCHAR2,
744: x_dependent_sty_id OUT NOCOPY strm_rec_type
745: )

Line 742: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,

738: PROCEDURE get_dep_no_prc_stream_type
739: (
740: p_khr_id IN okl_k_headers_full_v.id%TYPE,
741: p_primary_sty_id IN okl_strm_type_b.id%TYPE,
742: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
743: x_return_status OUT NOCOPY VARCHAR2,
744: x_dependent_sty_id OUT NOCOPY strm_rec_type
745: )
746:

Line 844: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

840: PROCEDURE get_primary_stream_type
841: (
842: p_khr_id IN okl_k_headers_full_v.id%TYPE,
843: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
844: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
845: x_return_status OUT NOCOPY VARCHAR2,
846: x_primary_sty_id OUT NOCOPY strm_rec_type
847: )
848:

Line 955: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

951:
952: PROCEDURE get_primary_stream_types
953: (
954: p_khr_id IN okl_k_headers_full_v.id%TYPE,
955: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
956: x_return_status OUT NOCOPY VARCHAR2,
957: x_primary_sty_id OUT NOCOPY okl_strm_type_id_tbl_type
958: )
959:

Line 1057: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

1053:
1054: PROCEDURE get_dependent_stream_type
1055: (
1056: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1057: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1058: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1059: x_return_status OUT NOCOPY VARCHAR2,
1060: x_dependent_sty_id OUT NOCOPY strm_rec_type
1061: )

Line 1058: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

1054: PROCEDURE get_dependent_stream_type
1055: (
1056: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1057: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1058: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1059: x_return_status OUT NOCOPY VARCHAR2,
1060: x_dependent_sty_id OUT NOCOPY strm_rec_type
1061: )
1062:

Line 1156: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,

1152:
1153: PROCEDURE get_dependent_stream_type
1154: (
1155: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1156: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1157: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1158: x_return_status OUT NOCOPY VARCHAR2,
1159: x_dependent_sty_id OUT NOCOPY strm_rec_type
1160: )

Line 1157: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

1153: PROCEDURE get_dependent_stream_type
1154: (
1155: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1156: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1157: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1158: x_return_status OUT NOCOPY VARCHAR2,
1159: x_dependent_sty_id OUT NOCOPY strm_rec_type
1160: )
1161:

Line 1254: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,

1250: END get_dependent_stream_type;
1251: PROCEDURE get_dependent_stream_types
1252: (
1253: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1254: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1255: x_return_status OUT NOCOPY VARCHAR2,
1256: x_dependent_sty_id OUT NOCOPY okl_strm_type_id_tbl_type
1257: )
1258:

Line 1349: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,

1345: PROCEDURE get_dependent_stream_types
1346: (
1347: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1348: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1349: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1350: x_return_status OUT NOCOPY VARCHAR2,
1351: x_dependent_sty_id OUT NOCOPY okl_strm_type_id_tbl_type
1352: )
1353:

Line 1443: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,

1439: PROCEDURE get_dependent_stream_type
1440: (
1441: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1442: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1443: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1444: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1445: x_return_status OUT NOCOPY VARCHAR2,
1446: x_dependent_sty_id OUT NOCOPY strm_rec_type
1447: )

Line 1444: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,

1440: (
1441: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1442: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1443: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1444: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1445: x_return_status OUT NOCOPY VARCHAR2,
1446: x_dependent_sty_id OUT NOCOPY strm_rec_type
1447: )
1448:

Line 1553: p_primary_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,

1549: PROCEDURE get_dependent_stream_type
1550: (
1551: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1552: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1553: p_primary_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1554: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1555: x_return_status OUT NOCOPY VARCHAR2,
1556: x_dependent_sty_id OUT NOCOPY strm_rec_type
1557: )

Line 1554: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,

1550: (
1551: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1552: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1553: p_primary_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1554: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1555: x_return_status OUT NOCOPY VARCHAR2,
1556: x_dependent_sty_id OUT NOCOPY strm_rec_type
1557: )
1558:

Line 3043: l_old_sty_id okl_strm_type_b.ID%TYPE;

3039: l_stmv_rec okl_streams_pub.stmv_rec_type;
3040: lx_stmv_rec okl_streams_pub.stmv_rec_type;
3041: --srsreeni bug 5869271 start add
3042: l_old_cle_id okc_k_lines_b.ID%TYPE;
3043: l_old_sty_id okl_strm_type_b.ID%TYPE;
3044: l_old_str_stmv_rec okl_streams_pub.stmv_rec_type;
3045: l_old_acr_stmv_rec okl_streams_pub.stmv_rec_type;
3046: l_last_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;
3047: l_last_acr_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;

Line 4987: okl_strm_type_b sty

4983: IS
4984: SELECT nvl(sum(ele.AMOUNT),0)
4985: FROM okl_strm_elements ele,
4986: okl_streams str,
4987: okl_strm_type_b sty
4988: WHERE str.khr_id = chrId
4989: AND nvl(str.kle_id, -1) = kleid
4990: AND str.sty_id = sty.id
4991: AND str.say_code = 'CURR'

Line 5057: okl_strm_type_b b

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;
5061:

Line 5587: okl_strm_type_b sty

5583: IS
5584: SELECT NVL(SUM(ele.AMOUNT),0) amount
5585: FROM okl_strm_elements ele,
5586: okl_streams str,
5587: okl_strm_type_b sty
5588: WHERE str.khr_id = p_chr_id
5589: AND NVL(str.kle_id, -1) = p_kle_id
5590: AND str.sty_id = sty.id
5591: AND str.say_code = 'CURR'

Line 5605: okl_strm_type_b sty

5601: IS
5602: SELECT NVL(SUM(ele.AMOUNT),0) amount
5603: FROM okl_strm_elements ele,
5604: okl_streams str,
5605: okl_strm_type_b sty
5606: WHERE str.khr_id = p_chr_id
5607: AND NVL(str.kle_id, -1) = p_kle_id
5608: AND str.sty_id = sty.id
5609: AND str.say_code = 'CURR'

Line 5634: okl_strm_type_b b

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;
5638:

Line 6878: , OKL_STRM_TYPE_B STY

6874: , SEL.SE_LINE_NUMBER
6875: , SEL.COMMENTS
6876: FROM OKL_STREAMS STM
6877: , OKL_STRM_ELEMENTS SEL
6878: , OKL_STRM_TYPE_B STY
6879: WHERE SEL.STM_ID = STM.ID
6880: AND STM.KHR_ID = cp_chr_id
6881: AND STM.KLE_ID = cp_cle_id
6882: AND (nvl(STM.purpose_code,'ORIG') = (select nvl(si.PURPOSE_CODE,'ORIG') from okl_stream_interfaces si

Line 7035: , OKL_STRM_TYPE_B STY

7031: , cp_cle_id OKC_K_LINES_B.ID%TYPE
7032: , cp_purpose VARCHAR2) IS
7033: SELECT STM.ID STREAM_ID
7034: FROM OKL_STREAMS STM
7035: , OKL_STRM_TYPE_B STY
7036: WHERE STM.KHR_ID = cp_chr_id
7037: AND STM.KLE_ID = cp_cle_id
7038: AND (nvl(STM.purpose_code,'ORIGIN') = cp_purpose)
7039: AND STM.SAY_CODE = 'CURR'

Line 7919: , OKL_STRM_TYPE_B STY -- vdamerla Forward Ported Bug 6082209

7915: , SEL.SE_LINE_NUMBER
7916: , SEL.COMMENTS -- vdamerla Forward Ported Bug 6344223
7917: FROM OKL_STREAMS STM
7918: , OKL_STRM_ELEMENTS SEL
7919: , OKL_STRM_TYPE_B STY -- vdamerla Forward Ported Bug 6082209
7920: WHERE SEL.STM_ID = STM.ID
7921: AND STM.KHR_ID = cp_chr_id
7922: AND STM.KLE_ID = cp_cle_id
7923: AND (nvl(STM.purpose_code,'ORIG') = (select nvl(si.PURPOSE_CODE,'ORIG') from okl_stream_interfaces si

Line 8019: , OKL_STRM_TYPE_B STY

8015: , SEL.SE_LINE_NUMBER
8016: , SEL.COMMENTS
8017: FROM OKL_STREAMS STM
8018: , OKL_STRM_ELEMENTS SEL
8019: , OKL_STRM_TYPE_B STY
8020: WHERE SEL.STM_ID = STM.ID
8021: AND STM.KHR_ID = cp_chr_id
8022: AND STM.KLE_ID IS NULL
8023: AND (nvl(STM.purpose_code,'ORIG') = (select nvl(si.PURPOSE_CODE,'ORIG') from okl_stream_interfaces si

Line 8064: cp_sty_id OKL_STRM_TYPE_B.ID%TYPE) IS

8060: and ole.id=cle.orig_system_id1;
8061: --smadhava - Bug# 6149951 - Added - End
8062: --Added by vdamerla for bug 6149951
8063: CURSOR c_chk_accrual_sty_on_pdt(cp_pdt_id OKL_PRODUCTS.ID%TYPE,
8064: cp_sty_id OKL_STRM_TYPE_B.ID%TYPE) IS
8065: SELECT 'Y'
8066: FROM OKL_STRM_TYPE_B sty,
8067: OKL_PROD_STRM_TYPES psty
8068: WHERE sty.id = psty.sty_id

Line 8066: FROM OKL_STRM_TYPE_B sty,

8062: --Added by vdamerla for bug 6149951
8063: CURSOR c_chk_accrual_sty_on_pdt(cp_pdt_id OKL_PRODUCTS.ID%TYPE,
8064: cp_sty_id OKL_STRM_TYPE_B.ID%TYPE) IS
8065: SELECT 'Y'
8066: FROM OKL_STRM_TYPE_B sty,
8067: OKL_PROD_STRM_TYPES psty
8068: WHERE sty.id = psty.sty_id
8069: AND psty.pdt_id = cp_pdt_id
8070: AND psty.accrual_yn = 'Y'

Line 9594: FROM okl_strm_type_b stm,

9590: stm.stream_type_class stream_type_class,
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;

Line 9693: okl_strm_type_b sty,

9689: IS
9690: SELECT TO_NUMBER(sgn.value) sty_id,
9691: cle.id
9692: FROM okl_sgn_translations sgn,
9693: okl_strm_type_b sty,
9694: okl_subsidies_v sub,
9695: okl_k_lines kle,
9696: okc_statuses_b sts,
9697: okc_line_styles_b lse,

Line 10516: okl_strm_type_b sty_inc,

10512: AND kle.subsidy_id = sub.id;
10513: /*
10514: SELECT sty_inc.code strm_desc
10515: FROM okl_sgn_translations sgn,
10516: okl_strm_type_b sty_inc,
10517: okl_strm_type_b sty,
10518: okl_subsidies_v sub,
10519: okl_k_lines kle,
10520: okc_line_styles_b lse,

Line 10517: okl_strm_type_b sty,

10513: /*
10514: SELECT sty_inc.code strm_desc
10515: FROM okl_sgn_translations sgn,
10516: okl_strm_type_b sty_inc,
10517: okl_strm_type_b sty,
10518: okl_subsidies_v sub,
10519: okl_k_lines kle,
10520: okc_line_styles_b lse,
10521: okc_k_lines_b cle

Line 10534: CURSOR get_strm_type_code (p_sty_id IN okl_strm_type_b.ID%TYPE)

10530: AND sgn.jtot_object1_code = 'OKL_STRMTYP'
10531: AND kle.subsidy_id = sub.id;
10532: */
10533: -- New code for bug 4044089 by HKPATEL 12/02/2004
10534: CURSOR get_strm_type_code (p_sty_id IN okl_strm_type_b.ID%TYPE)
10535: IS
10536:
10537: SELECT code
10538: FROM okl_strm_type_b

Line 10538: FROM okl_strm_type_b

10534: CURSOR get_strm_type_code (p_sty_id IN okl_strm_type_b.ID%TYPE)
10535: IS
10536:
10537: SELECT code
10538: FROM okl_strm_type_b
10539: WHERE id = p_sty_id;
10540:
10541: --sechawla 20-Jul-09 PRB ESG Enhancements : check rebook option
10542: cursor get_rebook_type is

Line 11000: --TYPE okl_strm_type_id_tbl_type IS TABLE OF okl_strm_type_b.ID%TYPE

10996:
10997: l_passthru_percent NUMBER := 0;
10998: l_fee_type apps.OKL_K_LINES.FEE_TYPE%TYPE;
10999:
11000: --TYPE okl_strm_type_id_tbl_type IS TABLE OF okl_strm_type_b.ID%TYPE
11001: --INDEX BY BINARY_INTEGER;
11002: l_strm_type_id_tbl okl_strm_type_id_tbl_type;
11003:
11004:

Line 20132: okl_strm_type_b styb,

20128: CURSOR l_adv_arrears_csr (p_khr_id in NUMBER, p_cle_id in NUMBER) is
20129: select nvl( sll_rulb.rule_information10,'N') advance_or_arrears
20130: from okc_rules_b sll_rulb,
20131: okc_rules_b slh_rulb,
20132: okl_strm_type_b styb,
20133: okc_rule_groups_b rgpb
20134: where sll_rulb.rgp_id = rgpb.id
20135: and sll_rulb.rule_information_category = 'LASLL'
20136: and sll_rulb.dnz_chr_id = rgpb.dnz_chr_id

Line 20351: FROM okl_strm_type_b stm,

20347: stm.stream_type_class stream_type_class,
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;

Line 24909: FROM okl_strm_type_b stm,

24905: stm.stream_type_purpose,
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;

Line 25004: okl_strm_type_b sty

25000: SELECT NVL(kle.amount, 0) total_cap_fee
25001: FROM okl_k_lines kle,
25002: okc_k_lines_b cle,
25003: okc_k_items cim,
25004: okl_strm_type_b sty
25005: WHERE cle.dnz_chr_id = p_chr_id
25006: AND cle.id = kle.id
25007: AND cle.id = cim.cle_id
25008: AND cim.jtot_object1_code = 'OKL_STRMTYP'