APPS.OKL_STREAM_GENERATOR_PVT dependencies on OKL_STRM_TYPE_TL

Line 1624: okl_strm_type_tl styt

1620: sel.stream_element_date income_date
1621: FROM okl_strm_elements sel,
1622: okl_streams stm,
1623: okl_strm_type_b sty,
1624: okl_strm_type_tl styt
1625: WHERE stm.khr_id = p_khr_id
1626: AND stm.say_code = 'WORK'
1627: AND stm.id = sel.stm_id
1628: AND stm.sty_id = sty.id

Line 1874: okl_strm_type_tl styt

1870:
1871: CURSOR c_sty_name IS
1872: SELECT styt.name
1873: FROM okl_strm_type_b sty,
1874: okl_strm_type_tl styt
1875: WHERE sty.id = p_sty_id
1876: AND sty.version = '1.0' -- not really needed in 1159
1877: AND sty.id = styt.id
1878: AND styt.language = 'US'

Line 1885: okl_strm_type_tl styt

1881:
1882: CURSOR c_sty_id IS
1883: SELECT sty.id
1884: FROM okl_strm_type_b sty,
1885: okl_strm_type_tl styt
1886: WHERE styt.name = p_sty_name
1887: AND styt.language = 'US'
1888: AND styt.id = sty.id
1889: AND sty.version = '1.0' -- not really needed in 1159

Line 4175: from okl_strm_type_tl

4171: and object1_id1 = to_char( styId );
4172:
4173: Cursor c_strm_name ( styId NUMBER ) IS
4174: Select name
4175: from okl_strm_type_tl
4176: where language = 'US'
4177: and id = styId;
4178:
4179: l_subsidy_stream VARCHAR2(256);

Line 5456: from okl_strm_type_tl tl,

5452: sty.capitalize_yn capitalize_yn,
5453: kle.id line_id,
5454: sty.id styp_id,
5455: sty.stream_type_class stream_type_class
5456: from okl_strm_type_tl tl,
5457: okl_strm_type_v sty,
5458: okc_k_items cim,
5459: okl_k_lines_full_v kle,
5460: okc_line_styles_b ls

Line 7907: okl_strm_type_tl sty

7903: TO_NUMBER(NULL) residual_value
7904: FROM okc_rule_groups_b rgp,
7905: okc_rules_b rul1,
7906: okc_rules_b rul2,
7907: okl_strm_type_tl sty
7908: WHERE rul2.dnz_chr_id = khrid
7909: AND rul2.rule_information_category = 'LASLL'
7910: AND rul2.rgp_id = rgp.id
7911: AND rul1.rgp_id = rgp.id

Line 8330: from okl_strm_type_tl tl,

8326:
8327: Cursor c_stm_name IS
8328: Select sty.stream_type_subclass name,
8329: sty.stream_type_purpose stream_type_purpose
8330: from okl_strm_type_tl tl,
8331: okl_strm_type_v sty
8332: where tl.language = 'US'
8333: and sty.id = tl.id
8334: and tl.id = p_sty_id;

Line 8997: from okl_strm_type_tl tl,

8993:
8994: Cursor c_stm_name IS
8995: Select sty.stream_type_subclass name,
8996: sty.stream_type_purpose stream_type_purpose
8997: from okl_strm_type_tl tl,
8998: okl_strm_type_v sty
8999: where tl.language = 'US'
9000: and sty.id = tl.id
9001: and tl.id = p_sty_id;

Line 9440: okl_strm_type_tl stl,

9436:
9437: Cursor l_strms_csr ( khrId NUMBER, kleId NUMBER, strmname VARCHAR2) IS
9438: select stm.id strm_id
9439: from okl_strm_type_v sty,
9440: okl_strm_type_tl stl,
9441: okl_streams stm
9442: where stl.language = 'US'
9443: and stl.name = strmname
9444: and sty.id = stl.id

Line 10034: okl_strm_type_tl stl,

10030:
10031: Cursor l_strms_csr ( khrId NUMBER, kleId NUMBER, strmname VARCHAR2) IS
10032: select stm.id strm_id
10033: from okl_strm_type_v sty,
10034: okl_strm_type_tl stl,
10035: okl_streams stm
10036: where stl.language = 'US'
10037: and stl.name = strmname
10038: and sty.id = stl.id