DBA Data[Home] [Help]

APPS.OKL_STREAM_GENERATOR_PVT dependencies on OKC_STATUSES_B

Line 15: okc_statuses_b sts

11: (
12: select 1
13: from okc_k_lines_b kle,
14: okc_line_styles_b lse,
15: okc_statuses_b sts
16: where KLE.LSE_ID = LSE.ID
17: and lse.lty_code = 'SOLD_SERVICE'
18: and kle.chr_id = chrId
19: and sts.code = kle.sts_code

Line 4077: okc_statuses_b sts

4073: tl.name */
4074: from okl_k_lines_full_v kle,
4075: okc_line_styles_b lse,
4076: -- okc_k_lines_tl tl,
4077: okc_statuses_b sts
4078: where KLE.LSE_ID = LSE.ID
4079: and lse.lty_code = lnetype
4080: -- and tl.id = kle.id
4081: -- and tl.language = userenv('LANG')

Line 6266: okc_statuses_b sts

6262: where Exists(
6263: select kle.id
6264: from okl_k_lines_full_v kle,
6265: okc_line_styles_b lse,
6266: okc_statuses_b sts
6267: where KLE.LSE_ID = LSE.ID
6268: and lse.lty_code = 'SUBSIDY'
6269: and kle.dnz_chr_id = p_khr_id
6270: and sts.code = kle.sts_code

Line 11208: okc_statuses_b sts

11204: cursor l_line_csr IS
11205: select kle.id
11206: from okl_k_lines_full_v kle,
11207: okc_line_styles_b lse,
11208: okc_statuses_b sts
11209: where KLE.LSE_ID = LSE.ID
11210: and lse.lty_code in ('FREE_FORM1', 'FEE')
11211: AND nvl(kle.fee_type,'-99') in ( '-99', 'FINANCED', 'ROLLOVER')
11212: and kle.dnz_chr_id = p_khr_id