DBA Data[Home] [Help]

APPS.FA_ASSET_CALC_PVT dependencies on FA_ADDITIONS_B

Line 3490: fa_additions_b ad

3486: if (p_mrc_sob_type_code <> 'R') then
3487: select nvl(sum(allowed_deprn_limit_amount), 0)
3488: into px_asset_fin_rec_new.allowed_deprn_limit_amount
3489: from fa_books bk,
3490: fa_additions_b ad
3491: where bk.transaction_header_id_out is null
3492: and bk.group_asset_id = p_asset_hdr_rec.asset_id
3493: and bk.asset_id = ad.asset_id
3494: and bk.book_type_code = p_asset_hdr_rec.book_type_code

Line 3500: fa_additions_b ad

3496: else
3497: select nvl(sum(allowed_deprn_limit_amount), 0)
3498: into px_asset_fin_rec_new.allowed_deprn_limit_amount
3499: from fa_mc_books bk,
3500: fa_additions_b ad
3501: where bk.transaction_header_id_out is null
3502: and bk.group_asset_id = p_asset_hdr_rec.asset_id
3503: and bk.asset_id = ad.asset_id
3504: and bk.book_type_code = p_asset_hdr_rec.book_type_code

Line 3824: fa_additions_b ad

3820: if (p_mrc_sob_type_code <> 'R') then
3821: select nvl(sum(salvage_value), 0)
3822: into px_asset_fin_rec_new.salvage_value
3823: from fa_books bk,
3824: fa_additions_b ad
3825: where bk.transaction_header_id_out is null
3826: and bk.group_asset_id = p_asset_hdr_rec.asset_id
3827: and bk.asset_id = ad.asset_id
3828: and bk.book_type_code = p_asset_hdr_rec.book_type_code

Line 3834: fa_additions_b ad

3830: else
3831: select nvl(sum(salvage_value), 0)
3832: into px_asset_fin_rec_new.salvage_value
3833: from fa_mc_books bk,
3834: fa_additions_b ad
3835: where bk.transaction_header_id_out is null
3836: and bk.group_asset_id = p_asset_hdr_rec.asset_id
3837: and bk.asset_id = ad.asset_id
3838: and bk.book_type_code = p_asset_hdr_rec.book_type_code