DBA Data[Home] [Help]

APPS.OKL_ACCOUNTING_UTIL dependencies on OKL_TXL_ASSETS_B

Line 2908: OKL_TXL_ASSETS_B LN,

2904: CURSOR a_draft_csr IS
2905: SELECT
2906: DIST.POST_TO_GL
2907: FROM
2908: OKL_TXL_ASSETS_B LN,
2909: OKL_TRNS_ACC_DSTRS DIST
2910: WHERE
2911: LN.TAS_ID = p_trx_id
2912: AND LN.DNZ_KHR_ID =p_khr_id

Line 2934: ELSIF p_source_table = 'OKL_TXL_ASSETS_B' THEN

2930: CLOSE c_draft_csr;
2931:
2932: -- If the transaction is an asset transaction
2933:
2934: ELSIF p_source_table = 'OKL_TXL_ASSETS_B' THEN
2935:
2936: OPEN a_draft_csr;
2937: FETCH a_draft_csr INTO l_draft;
2938: IF a_draft_csr%NOTFOUND THEN

Line 3051: OKL_TXL_ASSETS_B txl,

3047: CURSOR fa_trx_st_dt_csr IS
3048: SELECT
3049: TXL.FA_TRX_DATE
3050: FROM
3051: OKL_TXL_ASSETS_B txl,
3052: OKL_TRX_ASSETS TRX,
3053: OKL_TRX_TYPES_V TRY
3054: WHERE
3055: TXL.ASSET_NUMBER = p_asset_number AND

Line 3100: OKL_TXL_ASSETS_B txl,

3096: CURSOR fa_trx_end_dt_csr IS
3097: SELECT
3098: MAX(TXL.FA_TRX_DATE)
3099: FROM
3100: OKL_TXL_ASSETS_B txl,
3101: OKL_TRX_ASSETS TRX,
3102: OKL_TRX_TYPES_V TRY
3103: WHERE
3104: TXL.ASSET_NUMBER = p_asset_number AND