APPS.OKL_SPLIT_ASSET_PVT dependencies on OKL_TRX_TYPES_TL

Line 3204: okl_trx_types_tl ttyp

3200: FROM Okl_Txl_Assets_V
3201: WHERE okl_txl_assets_v.kle_id = p_kle_id
3202: AND EXISTS (SELECT NULL
3203: FROM okl_trx_Assets trx,
3204: okl_trx_types_tl ttyp
3205: WHERE trx.id = okl_txl_assets_v.tas_id
3206: AND trx.tsu_code = 'ENTERED'
3207: AND trx.try_id = ttyp.id
3208: AND ttyp.name = 'Split Asset'

Line 3455: okl_trx_types_tl ttyp,

3451: FROM okl_txd_assets_b txd
3452: WHERE NVL(txd.asset_number,'-999999999999999') = p_asset_number
3453: AND EXISTS (SELECT NULL
3454: FROM okl_trx_Assets trx,
3455: okl_trx_types_tl ttyp,
3456: okl_txl_assets_b txl
3457: WHERE trx.id = txl.tas_id
3458: AND trx.try_id = ttyp.id
3459: AND ttyp.name = 'Split Asset'

Line 3540: okl_trx_types_tl ttyp,

3536: CURSOR asset_chk_curs3 (p_asset_number IN VARCHAR2, p_txdv_id IN NUMBER) IS
3537: SELECT 'Y'
3538: FROM okl_txd_assets_b txd,
3539: okl_txl_assets_b txl,
3540: okl_trx_types_tl ttyp,
3541: okl_trx_assets trx
3542: WHERE NVL(txd.asset_number,'-999999999999999') = p_asset_number
3543: AND txd.tal_id = txl.id
3544: AND txl.tas_id = trx.id

Line 3656: FROM OKL_TRX_TYPES_TL

3652: RETURN VARCHAR2 IS
3653: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
3654: CURSOR c_get_try_id(p_try_name OKL_TRX_TYPES_V.NAME%TYPE) IS
3655: SELECT id
3656: FROM OKL_TRX_TYPES_TL
3657: WHERE UPPER(name) = UPPER(p_try_name)
3658: AND LANGUAGE = 'US';
3659: BEGIN
3660: IF (p_try_name = OKL_API.G_MISS_CHAR) OR

Line 5815: okl_trx_types_tl ttyp

5811: AND tas.tas_type = 'ALI'
5812: AND tas.tsu_code = 'ENTERED'
5813: AND EXISTS (SELECT NULL
5814: FROM
5815: okl_trx_types_tl ttyp
5816: WHERE tas.try_id = ttyp.id
5817: AND ttyp.name = 'Split Asset'
5818: AND ttyp.LANGUAGE = 'US');
5819: