DBA Data[Home] [Help]

APPS.OKL_VENDORMERGE_GRP dependencies on OKL_STRM_TYPE_TL

Line 175: , OKL_STRM_TYPE_TL STY

171: CURSOR fee_name_csr(p_cle_id NUMBER)
172: IS
173: SELECT STY.NAME FEE_NAME
174: FROM OKC_K_ITEMS ITM
175: , OKL_STRM_TYPE_TL STY
176: , OKC_K_LINES_B CLE
177: WHERE ITM.OBJECT1_ID1 = STY.ID
178: AND ITM.JTOT_OBJECT1_CODE = 'OKL_STRMTYP'
179: AND STY.LANGUAGE = USERENV('LANG')

Line 188: l_fee_name OKL_STRM_TYPE_TL.NAME%TYPE;

184: SELECT NAME
185: FROM okc_k_lines_v
186: WHERE id = p_cle_id
187: AND lse_id = 48;
188: l_fee_name OKL_STRM_TYPE_TL.NAME%TYPE;
189:
190: BEGIN
191: l_return_status := OKL_API.G_RET_STS_SUCCESS;
192: l_debug_enabled := okl_debug_pub.check_log_enabled;