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 5403: l_try_name OKL_TRX_TYPES_TL.NAME%TYPE;

5399: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
5400: l_dummy VARCHAR2(1) := OKL_API.G_TRUE;
5401: l_try_id NUMBER;
5402: l_org_id NUMBER;
5403: l_try_name OKL_TRX_TYPES_TL.NAME%TYPE;
5404:
5405: --
5406: --
5407: l_tplv_rec tplv_rec_type;

Line 5416: OKL_TRX_TYPES_TL TRYT

5412: CURSOR l_tryv_csr(p_try_name varchar2) IS
5413: select TRYB.ID
5414: FROM
5415: OKL_TRX_TYPES_B TRYB,
5416: OKL_TRX_TYPES_TL TRYT
5417: WHERE
5418: TRYB.ID = TRYT.ID and
5419: TRYT.LANGUAGE = 'US' and
5420: TRYT.NAME = p_try_name; -- cklee 05/04/2004