APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_STRM_TYPE_TL

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

5152: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
5153: SELECT sll.rule_information2 start_date,
5154: SLL.rule_information3 periods,
5155: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
5156: ( select STYT.NAME from OKL_STRM_TYPE_B STY ,OKL_STRM_TYPE_TL STYT where STY.ID = STYT.ID AND STYT.LANGUAGE = USERENV ( 'LANG' )
5157: AND to_number(SLH.OBJECT1_ID1) = STY.ID ) STREAM_TYPE
5158: --styt.name stream_type
5159: FROM okc_rules_b sll,
5160: okc_rules_b slh,

Line 5163: --okl_strm_type_tl styt

5159: FROM okc_rules_b sll,
5160: okc_rules_b slh,
5161: okc_rule_groups_b rgp
5162: --okl_strm_type_b sty,
5163: --okl_strm_type_tl styt
5164: WHERE rgp.dnz_chr_id = p_khr_id
5165: AND rgp.cle_id = p_kle_id
5166: AND rgp.rgd_code = 'LALEVL'
5167: AND rgp.id = slh.rgp_id

Line 5188: okl_strm_type_tl styt

5184: FROM okc_rules_b sll,
5185: okc_rules_b slh,
5186: okc_rule_groups_b rgp,
5187: okl_strm_type_b sty,
5188: okl_strm_type_tl styt
5189: WHERE rgp.dnz_chr_id = p_khr_id
5190: AND rgp.cle_id = p_kle_id
5191: AND rgp.rgd_code = 'LALEVL'
5192: AND rgp.id = slh.rgp_id

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

5202:
5203: --Bug#3877032
5204: CURSOR c_strm_slh_ext (p_khr_id OKC_K_HEADERS_B.ID%TYPE,
5205: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
5206: SELECT (select STYT.NAME from OKL_STRM_TYPE_B STY ,OKL_STRM_TYPE_TL STYT
5207: where STY.ID = STYT.ID AND STYT.LANGUAGE = USERENV ( 'LANG' )
5208: AND to_number(RULE.OBJECT1_ID1) = STY.ID ) STREAM_TYPE,
5209: rule.id rule_id,
5210: rgp.id rgp_id

Line 5214: --okl_strm_type_tl styt

5210: rgp.id rgp_id
5211: FROM okc_rules_b rule,
5212: okc_rule_groups_b rgp
5213: --okl_strm_type_b sty, Bug 4929573
5214: --okl_strm_type_tl styt
5215: WHERE rgp.cle_id = p_kle_id
5216: AND rgp.dnz_chr_id = p_khr_id
5217: AND rgp.rgd_code = 'LALEVL'
5218: AND rgp.id = rule.rgp_id

Line 5264: okl_strm_type_tl styt

5260: FROM okc_rules_b sll,
5261: okc_rules_b slh,
5262: okc_rule_groups_b rgp,
5263: okl_strm_type_b sty,
5264: okl_strm_type_tl styt
5265: WHERE rgp.dnz_chr_id = p_khr_id
5266: AND rgp.cle_id = p_kle_id
5267: AND rgp.rgd_code = 'LALEVL'
5268: AND rgp.id = slh.rgp_id

Line 6225: okl_strm_type_tl styt

6221: FROM okc_rules_b sll,
6222: okc_rules_b slh,
6223: okc_rule_groups_b rgp,
6224: okl_strm_type_b sty,
6225: okl_strm_type_tl styt
6226: WHERE rgp.dnz_chr_id = chrID
6227: AND rgp.cle_id = feeLine
6228: AND rgp.rgd_code = 'LALEVL'
6229: AND rgp.id = slh.rgp_id

Line 6248: okl_strm_type_tl styt

6244: SELECT slh.id
6245: FROM okc_rules_b slh,
6246: okc_rule_groups_b rgp,
6247: okl_strm_type_b sty,
6248: okl_strm_type_tl styt
6249: WHERE rgp.dnz_chr_id = chrID
6250: AND rgp.cle_id = feeLine
6251: AND rgp.rgd_code = 'LALEVL'
6252: AND rgp.id = slh.rgp_id

Line 6668: okl_strm_type_tl styt

6664: FROM okc_rules_b sll,
6665: okc_rules_b slh,
6666: okc_rule_groups_b rgp,
6667: okl_strm_type_b sty,
6668: okl_strm_type_tl styt
6669: WHERE rgp.dnz_chr_id = chrID
6670: AND rgp.cle_id = feeLine
6671: AND rgp.rgd_code = 'LALEVL'
6672: AND rgp.id = slh.rgp_id

Line 6691: okl_strm_type_tl styt

6687: SELECT slh.id
6688: FROM okc_rules_b slh,
6689: okc_rule_groups_b rgp,
6690: okl_strm_type_b sty,
6691: okl_strm_type_tl styt
6692: WHERE rgp.dnz_chr_id = chrID
6693: AND rgp.cle_id = feeLine
6694: AND rgp.rgd_code = 'LALEVL'
6695: AND rgp.id = slh.rgp_id

Line 12260: okl_strm_type_tl styt

12256: rgp.id rgp_id
12257: FROM okc_rules_b rule,
12258: okc_rule_groups_b rgp,
12259: okl_strm_type_b sty,
12260: okl_strm_type_tl styt
12261: WHERE NVL(rgp.cle_id, -1) = p_kle_id
12262: AND rgp.dnz_chr_id = p_khr_id
12263: AND rgp.rgd_code = 'LALEVL'
12264: AND rgp.id = rule.rgp_id