APPS.OKL_SPLIT_ASSET_PVT dependencies on OKL_TRX_TYPES_TL

Line 3176: okl_trx_types_tl ttyp

3172: FROM Okl_Txl_Assets_V
3173: WHERE okl_txl_assets_v.kle_id = p_kle_id
3174: AND EXISTS (SELECT NULL
3175: FROM okl_trx_Assets trx,
3176: okl_trx_types_tl ttyp
3177: WHERE trx.id = okl_txl_assets_v.tas_id
3178: AND trx.tsu_code = 'ENTERED'
3179: AND trx.try_id = ttyp.id
3180: AND ttyp.name = 'Split Asset'

Line 3427: okl_trx_types_tl ttyp,

3423: FROM okl_txd_assets_b txd
3424: WHERE NVL(txd.asset_number,'-999999999999999') = p_asset_number
3425: AND EXISTS (SELECT NULL
3426: FROM okl_trx_Assets trx,
3427: okl_trx_types_tl ttyp,
3428: okl_txl_assets_b txl
3429: WHERE trx.id = txl.tas_id
3430: AND trx.try_id = ttyp.id
3431: AND ttyp.name = 'Split Asset'

Line 3512: okl_trx_types_tl ttyp,

3508: CURSOR asset_chk_curs3 (p_asset_number IN VARCHAR2, p_txdv_id IN NUMBER) IS
3509: SELECT 'Y'
3510: FROM okl_txd_assets_b txd,
3511: okl_txl_assets_b txl,
3512: okl_trx_types_tl ttyp,
3513: okl_trx_assets trx
3514: WHERE NVL(txd.asset_number,'-999999999999999') = p_asset_number
3515: AND txd.tal_id = txl.id
3516: AND txl.tas_id = trx.id

Line 3628: FROM OKL_TRX_TYPES_TL

3624: RETURN VARCHAR2 IS
3625: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
3626: CURSOR c_get_try_id(p_try_name OKL_TRX_TYPES_V.NAME%TYPE) IS
3627: SELECT id
3628: FROM OKL_TRX_TYPES_TL
3629: WHERE UPPER(name) = UPPER(p_try_name)
3630: AND LANGUAGE = 'US';
3631: BEGIN
3632: IF (p_try_name = OKL_API.G_MISS_CHAR) OR

Line 5787: okl_trx_types_tl ttyp

5783: AND tas.tas_type = 'ALI'
5784: AND tas.tsu_code = 'ENTERED'
5785: AND EXISTS (SELECT NULL
5786: FROM
5787: okl_trx_types_tl ttyp
5788: WHERE tas.try_id = ttyp.id
5789: AND ttyp.name = 'Split Asset'
5790: AND ttyp.LANGUAGE = 'US');
5791: