DBA Data[Home] [Help]

APPS.OKL_BLK_AST_UPD_PVT dependencies on OKL_TRX_TYPES_TL

Line 884: FROM OKL_TRX_TYPES_TL

880: RETURN VARCHAR2 IS
881: x_return_status VARCHAR2(3) := OKC_API.G_RET_STS_SUCCESS;
882: CURSOR c_get_try_id(p_try_name OKL_TRX_TYPES_V.NAME%TYPE) IS
883: SELECT id
884: FROM OKL_TRX_TYPES_TL
885: WHERE upper(name) = upper(p_try_name)
886: AND language = 'US';
887: BEGIN
888: IF (p_try_name = OKC_API.G_MISS_CHAR) OR

Line 1342: FROM okl_trx_types_tl

1338: AND meaning = mng;
1339:
1340: CURSOR Transaction_Type_csr (p_transaction_type IN okl_trx_types_v.name%TYPE ) IS
1341: SELECT id
1342: FROM okl_trx_types_tl
1343: WHERE name = p_transaction_type
1344: AND language = 'US';
1345:
1346: l_Trx_Type_rec Transaction_Type_csr%ROWTYPE;