DBA Data[Home] [Help]

APPS.OKL_ACCOUNTING_UTIL dependencies on OKL_TXL_ASSETS_B

Line 2906: OKL_TXL_ASSETS_B LN,

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

Line 2932: ELSIF p_source_table = 'OKL_TXL_ASSETS_B' THEN

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

Line 3049: OKL_TXL_ASSETS_B txl,

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

Line 3098: OKL_TXL_ASSETS_B txl,

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