APPS.OKL_MAINTAIN_CONTRACT_PVT dependencies on OKC_LINE_STYLES_B

Line 41: FROM okc_line_styles_b lse,

37:
38: --get the top line
39: CURSOR c_get_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
40: SELECT cle.id top_line
41: FROM okc_line_styles_b lse,
42: okc_k_lines_b cle
43: WHERE cle.dnz_chr_id = p_dnz_chr_id
44: AND cle.cle_id IS NULL
45: AND cle.chr_id = cle.dnz_chr_id

Line 81: okc_line_styles_b lse

77: SELECT 'Y'
78: FROM DUAL
79: WHERE EXISTS (select '1'
80: from okc_k_lines_v kle,
81: okc_line_styles_b lse
82: where kle.name = p_asset_number
83: and kle.lse_id = lse.id
84: and lse.lty_code = 'FREE_FORM1');
85:

Line 102: OKC_LINE_STYLES_B lse

98: Select txlv.id,
99: txlv.asset_number
100: From OKL_TXL_ASSETS_V txlv,
101: OKC_K_LINES_B cle,
102: OKC_LINE_STYLES_B lse
103: Where txlv.kle_id = cle.id
104: And cle.lse_id = lse.id
105: And lse.lty_code = 'FIXED_ASSET'
106: And cle.cle_id = p_finasst_id

Line 119: OKC_LINE_STYLES_B lse

115: txdv.asset_number
116: From OKL_TXD_ASSETS_V txdv,
117: OKL_TXL_ASSETS_V txlv,
118: OKC_K_LINES_B cle,
119: OKC_LINE_STYLES_B lse
120: Where txdv.tal_id = txlv.id
121: And txlv.kle_id = cle.id
122: And cle.lse_id = lse.id
123: And lse.lty_code = 'FIXED_ASSET'