APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_STRM_TYPE_TL

Line 4769: ( select STYT.NAME from OKL_STRM_TYPE_B STY ,OKL_STRM_TYPE_TL STYT where STY.ID = STYT.ID AND STYT.LANGUAGE = USERENV ( 'LANG' )

4765: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
4766: SELECT sll.rule_information2 start_date,
4767: SLL.rule_information3 periods,
4768: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
4769: ( select STYT.NAME from OKL_STRM_TYPE_B STY ,OKL_STRM_TYPE_TL STYT where STY.ID = STYT.ID AND STYT.LANGUAGE = USERENV ( 'LANG' )
4770: AND to_number(SLH.OBJECT1_ID1) = STY.ID ) STREAM_TYPE
4771: --styt.name stream_type
4772: FROM okc_rules_b sll,
4773: okc_rules_b slh,

Line 4776: --okl_strm_type_tl styt

4772: FROM okc_rules_b sll,
4773: okc_rules_b slh,
4774: okc_rule_groups_b rgp
4775: --okl_strm_type_b sty,
4776: --okl_strm_type_tl styt
4777: WHERE rgp.dnz_chr_id = p_khr_id
4778: AND rgp.cle_id = p_kle_id
4779: AND rgp.rgd_code = 'LALEVL'
4780: AND rgp.id = slh.rgp_id

Line 4801: okl_strm_type_tl styt

4797: FROM okc_rules_b sll,
4798: okc_rules_b slh,
4799: okc_rule_groups_b rgp,
4800: okl_strm_type_b sty,
4801: okl_strm_type_tl styt
4802: WHERE rgp.dnz_chr_id = p_khr_id
4803: AND rgp.cle_id = p_kle_id
4804: AND rgp.rgd_code = 'LALEVL'
4805: AND rgp.id = slh.rgp_id

Line 4819: SELECT (select STYT.NAME from OKL_STRM_TYPE_B STY ,OKL_STRM_TYPE_TL STYT

4815:
4816: --Bug#3877032
4817: CURSOR c_strm_slh_ext (p_khr_id OKC_K_HEADERS_B.ID%TYPE,
4818: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
4819: SELECT (select STYT.NAME from OKL_STRM_TYPE_B STY ,OKL_STRM_TYPE_TL STYT
4820: where STY.ID = STYT.ID AND STYT.LANGUAGE = USERENV ( 'LANG' )
4821: AND to_number(RULE.OBJECT1_ID1) = STY.ID ) STREAM_TYPE,
4822: rule.id rule_id,
4823: rgp.id rgp_id

Line 4827: --okl_strm_type_tl styt

4823: rgp.id rgp_id
4824: FROM okc_rules_b rule,
4825: okc_rule_groups_b rgp
4826: --okl_strm_type_b sty, Bug 4929573
4827: --okl_strm_type_tl styt
4828: WHERE rgp.cle_id = p_kle_id
4829: AND rgp.dnz_chr_id = p_khr_id
4830: AND rgp.rgd_code = 'LALEVL'
4831: AND rgp.id = rule.rgp_id

Line 4877: okl_strm_type_tl styt

4873: FROM okc_rules_b sll,
4874: okc_rules_b slh,
4875: okc_rule_groups_b rgp,
4876: okl_strm_type_b sty,
4877: okl_strm_type_tl styt
4878: WHERE rgp.dnz_chr_id = p_khr_id
4879: AND rgp.cle_id = p_kle_id
4880: AND rgp.rgd_code = 'LALEVL'
4881: AND rgp.id = slh.rgp_id

Line 5838: okl_strm_type_tl styt

5834: FROM okc_rules_b sll,
5835: okc_rules_b slh,
5836: okc_rule_groups_b rgp,
5837: okl_strm_type_b sty,
5838: okl_strm_type_tl styt
5839: WHERE rgp.dnz_chr_id = chrID
5840: AND rgp.cle_id = feeLine
5841: AND rgp.rgd_code = 'LALEVL'
5842: AND rgp.id = slh.rgp_id

Line 5861: okl_strm_type_tl styt

5857: SELECT slh.id
5858: FROM okc_rules_b slh,
5859: okc_rule_groups_b rgp,
5860: okl_strm_type_b sty,
5861: okl_strm_type_tl styt
5862: WHERE rgp.dnz_chr_id = chrID
5863: AND rgp.cle_id = feeLine
5864: AND rgp.rgd_code = 'LALEVL'
5865: AND rgp.id = slh.rgp_id

Line 6281: okl_strm_type_tl styt

6277: FROM okc_rules_b sll,
6278: okc_rules_b slh,
6279: okc_rule_groups_b rgp,
6280: okl_strm_type_b sty,
6281: okl_strm_type_tl styt
6282: WHERE rgp.dnz_chr_id = chrID
6283: AND rgp.cle_id = feeLine
6284: AND rgp.rgd_code = 'LALEVL'
6285: AND rgp.id = slh.rgp_id

Line 6304: okl_strm_type_tl styt

6300: SELECT slh.id
6301: FROM okc_rules_b slh,
6302: okc_rule_groups_b rgp,
6303: okl_strm_type_b sty,
6304: okl_strm_type_tl styt
6305: WHERE rgp.dnz_chr_id = chrID
6306: AND rgp.cle_id = feeLine
6307: AND rgp.rgd_code = 'LALEVL'
6308: AND rgp.id = slh.rgp_id

Line 11837: okl_strm_type_tl styt

11833: rgp.id rgp_id
11834: FROM okc_rules_b rule,
11835: okc_rule_groups_b rgp,
11836: okl_strm_type_b sty,
11837: okl_strm_type_tl styt
11838: WHERE NVL(rgp.cle_id, -1) = p_kle_id
11839: AND rgp.dnz_chr_id = p_khr_id
11840: AND rgp.rgd_code = 'LALEVL'
11841: AND rgp.id = rule.rgp_id