DBA Data[Home] [Help]

APPS.OKL_LA_STREAM_PVT dependencies on OKL_STRM_TYPE_V

Line 7201: --okl_strm_type_v sty,

7197: Cursor l_secdep_csr( chrId NUMBER,pdtId NUMBER, pp VARCHAR2 ) is
7198: Select ele.id
7199: From okl_strm_elements ele,
7200: okl_streams str,
7201: --okl_strm_type_v sty,
7202: OKL_STRM_TMPT_LINES_UV sty,
7203: okl_k_lines_full_v kle,
7204: okc_line_styles_b lse,
7205: okc_statuses_b sts

Line 15359: okl_strm_type_v sty

15355: crl.rule_information13,
15356: crl.rule_information10
15357: FROM okc_rule_groups_b crg,
15358: okc_rules_b crl,
15359: okl_strm_type_v sty
15360: WHERE crl.rgp_id = crg.id
15361: AND crg.rgd_code = rgcode
15362: AND crl.rule_information_category = rlcat
15363: AND crg.dnz_chr_id = chrId

Line 17651: okl_strm_type_v sty

17647: crl.rule_information13,
17648: crl.rule_information10
17649: FROM okc_rule_groups_b crg,
17650: okc_rules_b crl,
17651: okl_strm_type_v sty
17652: WHERE crl.rgp_id = crg.id
17653: AND crg.rgd_code = rgcode
17654: AND crl.rule_information_category = rlcat
17655: AND crg.dnz_chr_id = chrId

Line 19805: okl_strm_type_v sty

19801: IS
19802: SELECT count(crl.id)
19803: FROM okc_rule_groups_b crg,
19804: okc_rules_b crl,
19805: okl_strm_type_v sty
19806: WHERE crl.rgp_id = crg.id
19807: AND crg.rgd_code = 'LALEVL'
19808: AND crl.rule_information_category = 'LASLH'
19809: AND crg.dnz_chr_id = chrId

Line 19912: okl_strm_type_v sty

19908: IS
19909: SELECT count(crl.id)
19910: FROM okc_rule_groups_b crg,
19911: okc_rules_b crl,
19912: okl_strm_type_v sty
19913: WHERE crl.rgp_id = crg.id
19914: AND crg.rgd_code = 'LALEVL'
19915: AND crl.rule_information_category = 'LASLH'
19916: AND crg.dnz_chr_id = chrId