DBA Data[Home] [Help]

APPS.IGI_IAC_REINSTATE_PKG dependencies on FA_ADDITIONS

Line 3332: fa_additions_b fab

3328: fth.mass_reference_id,
3329: fth.transaction_subtype,
3330: fab.asset_category_id
3331: FROM fa_transaction_headers fth,
3332: fa_additions_b fab
3333: WHERE fth.asset_id = fab.asset_id
3334: AND fth.transaction_header_id = p_trx_hdr_id;
3335:
3336: -- local variables

Line 3339: l_asset_num FA_ADDITIONS.asset_number%TYPE;

3335:
3336: -- local variables
3337: l_path VARCHAR2(150);
3338: l_retirement_type VARCHAR2(5);
3339: l_asset_num FA_ADDITIONS.asset_number%TYPE;
3340:
3341: l_fa_trx_headers c_fa_trx_headers%ROWTYPE;
3342: l_ret_rec FA_API_TYPES.asset_retire_rec_type;
3343: l_prd_rec IGI_IAC_TYPES.prd_rec;

Line 3428: FROM fa_additions_b

3424:
3425: -- get the asset number for easier debugging
3426: SELECT asset_number
3427: INTO l_asset_num
3428: FROM fa_additions_b
3429: WHERE asset_id = p_asset_id;
3430: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'There is an IAC effect on the asset: '||l_asset_num);
3431:
3432: -- bug 2480915 start, call ytd preprocessor to populate igi_iac_fa_deprn