DBA Data[Home] [Help]

APPS.OKL_LA_STREAM_PVT dependencies on OKL_STRM_TYPE_V

Line 5785: --okl_strm_type_v sty,

5781: Cursor l_secdep_csr( chrId NUMBER,pdtId NUMBER, pp VARCHAR2 ) is
5782: Select ele.id
5783: From okl_strm_elements ele,
5784: okl_streams str,
5785: --okl_strm_type_v sty,
5786: OKL_STRM_TMPT_LINES_UV sty,
5787: okl_k_lines_full_v kle,
5788: okc_line_styles_b lse,
5789: okc_statuses_b sts

Line 13256: okl_strm_type_v sty

13252: crl.rule_information13,
13253: crl.rule_information10
13254: FROM okc_rule_groups_b crg,
13255: okc_rules_b crl,
13256: okl_strm_type_v sty
13257: WHERE crl.rgp_id = crg.id
13258: AND crg.rgd_code = rgcode
13259: AND crl.rule_information_category = rlcat
13260: AND crg.dnz_chr_id = chrId

Line 15330: okl_strm_type_v sty

15326: crl.rule_information13,
15327: crl.rule_information10
15328: FROM okc_rule_groups_b crg,
15329: okc_rules_b crl,
15330: okl_strm_type_v sty
15331: WHERE crl.rgp_id = crg.id
15332: AND crg.rgd_code = rgcode
15333: AND crl.rule_information_category = rlcat
15334: AND crg.dnz_chr_id = chrId

Line 17200: okl_strm_type_v sty

17196: IS
17197: SELECT count(crl.id)
17198: FROM okc_rule_groups_b crg,
17199: okc_rules_b crl,
17200: okl_strm_type_v sty
17201: WHERE crl.rgp_id = crg.id
17202: AND crg.rgd_code = 'LALEVL'
17203: AND crl.rule_information_category = 'LASLH'
17204: AND crg.dnz_chr_id = chrId

Line 17306: okl_strm_type_v sty

17302: IS
17303: SELECT count(crl.id)
17304: FROM okc_rule_groups_b crg,
17305: okc_rules_b crl,
17306: okl_strm_type_v sty
17307: WHERE crl.rgp_id = crg.id
17308: AND crg.rgd_code = 'LALEVL'
17309: AND crl.rule_information_category = 'LASLH'
17310: AND crg.dnz_chr_id = chrId