DBA Data[Home] [Help]

APPS.OKL_FUNDING_PVT dependencies on OKL_TRX_TYPES_TL

Line 1286: FROM okl_trx_types_tl

1282:
1283: CURSOR trans_csr(p_trx_name VARCHAR2)
1284: IS
1285: SELECT id
1286: FROM okl_trx_types_tl
1287: WHERE name = p_trx_name
1288: AND language = 'US'
1289: ;
1290:

Line 5266: l_try_name OKL_TRX_TYPES_TL.NAME%TYPE;

5262: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
5263: l_dummy VARCHAR2(1) := OKL_API.G_TRUE;
5264: l_try_id NUMBER;
5265: l_org_id NUMBER;
5266: l_try_name OKL_TRX_TYPES_TL.NAME%TYPE;
5267:
5268: --
5269: --
5270: l_tplv_rec tplv_rec_type;

Line 5279: OKL_TRX_TYPES_TL TRYT

5275: CURSOR l_tryv_csr(p_try_name varchar2) IS
5276: select TRYB.ID
5277: FROM
5278: OKL_TRX_TYPES_B TRYB,
5279: OKL_TRX_TYPES_TL TRYT
5280: WHERE
5281: TRYB.ID = TRYT.ID and
5282: TRYT.LANGUAGE = 'US' and
5283: TRYT.NAME = p_try_name; -- cklee 05/04/2004