APPS.OKL_MASS_REBOOK_PVT dependencies on OKL_TRX_TYPES_TL

Line 1373: FROM okl_trx_types_tl

1369: l_api_version NUMBER := 1.0;
1370:
1371: CURSOR try_csr(p_trx_type VARCHAR2) IS
1372: SELECT id
1373: FROM okl_trx_types_tl
1374: WHERE language = 'US'
1375: AND name = p_trx_type;
1376:
1377: CURSOR book_csr (p_asset_number okx_ast_bks_v.asset_number%TYPE,

Line 3071: okl_trx_types_tl ttyp,

3067: ---------------------------------------------------------------*/
3068: CURSOR trx_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3069: SELECT trx.id
3070: FROM okl_trx_assets trx,
3071: okl_trx_types_tl ttyp,
3072: okl_txl_assets_b txl
3073: WHERE trx.id = txl.tas_id
3074: AND trx.try_id = ttyp.id
3075: AND trx.tas_type = 'CRB'