DBA Data[Home] [Help]

APPS.OKL_BLK_AST_UPD_PVT dependencies on OKL_TRX_TYPES_TL

Line 852: FROM OKL_TRX_TYPES_TL

848: RETURN VARCHAR2 IS
849: x_return_status VARCHAR2(3) := OKC_API.G_RET_STS_SUCCESS;
850: CURSOR c_get_try_id(p_try_name OKL_TRX_TYPES_V.NAME%TYPE) IS
851: SELECT id
852: FROM OKL_TRX_TYPES_TL
853: WHERE upper(name) = upper(p_try_name)
854: AND language = 'US';
855: BEGIN
856: IF (p_try_name = OKC_API.G_MISS_CHAR) OR

Line 1310: FROM okl_trx_types_tl

1306: AND meaning = mng;
1307:
1308: CURSOR Transaction_Type_csr (p_transaction_type IN okl_trx_types_v.name%TYPE ) IS
1309: SELECT id
1310: FROM okl_trx_types_tl
1311: WHERE name = p_transaction_type
1312: AND language = 'US';
1313:
1314: l_Trx_Type_rec Transaction_Type_csr%ROWTYPE;