DBA Data[Home] [Help]

APPS.IGI_IAC_REINSTATE_PKG dependencies on FA_ADDITIONS

Line 3369: fa_additions_b fab

3365: fth.mass_reference_id,
3366: fth.transaction_subtype,
3367: fab.asset_category_id
3368: FROM fa_transaction_headers fth,
3369: fa_additions_b fab
3370: WHERE fth.asset_id = fab.asset_id
3371: AND fth.transaction_header_id = p_trx_hdr_id;
3372:
3373: -- local variables

Line 3376: l_asset_num FA_ADDITIONS.asset_number%TYPE;

3372:
3373: -- local variables
3374: l_path VARCHAR2(150);
3375: l_retirement_type VARCHAR2(5);
3376: l_asset_num FA_ADDITIONS.asset_number%TYPE;
3377:
3378: l_fa_trx_headers c_fa_trx_headers%ROWTYPE;
3379: l_ret_rec FA_API_TYPES.asset_retire_rec_type;
3380: l_prd_rec IGI_IAC_TYPES.prd_rec;

Line 3465: FROM fa_additions_b

3461:
3462: -- get the asset number for easier debugging
3463: SELECT asset_number
3464: INTO l_asset_num
3465: FROM fa_additions_b
3466: WHERE asset_id = p_asset_id;
3467: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'There is an IAC effect on the asset: '||l_asset_num);
3468:
3469: -- bug 2480915 start, call ytd preprocessor to populate igi_iac_fa_deprn