DBA Data[Home] [Help]

APPS.FA_ASSET_CALC_PVT dependencies on FA_ADDITIONS_B

Line 2746: fa_additions_b ad

2742: if (p_mrc_sob_type_code <> 'R') then
2743: select nvl(sum(allowed_deprn_limit_amount), 0)
2744: into px_asset_fin_rec_new.allowed_deprn_limit_amount
2745: from fa_books bk,
2746: fa_additions_b ad
2747: where bk.transaction_header_id_out is null
2748: and bk.group_asset_id = p_asset_hdr_rec.asset_id
2749: and bk.asset_id = ad.asset_id
2750: and bk.book_type_code = p_asset_hdr_rec.book_type_code

Line 2756: fa_additions_b ad

2752: else
2753: select nvl(sum(allowed_deprn_limit_amount), 0)
2754: into px_asset_fin_rec_new.allowed_deprn_limit_amount
2755: from fa_books_mrc_v bk,
2756: fa_additions_b ad
2757: where bk.transaction_header_id_out is null
2758: and bk.group_asset_id = p_asset_hdr_rec.asset_id
2759: and bk.asset_id = ad.asset_id
2760: and bk.book_type_code = p_asset_hdr_rec.book_type_code

Line 3065: fa_additions_b ad

3061: if (p_mrc_sob_type_code <> 'R') then
3062: select nvl(sum(salvage_value), 0)
3063: into px_asset_fin_rec_new.salvage_value
3064: from fa_books bk,
3065: fa_additions_b ad
3066: where bk.transaction_header_id_out is null
3067: and bk.group_asset_id = p_asset_hdr_rec.asset_id
3068: and bk.asset_id = ad.asset_id
3069: and bk.book_type_code = p_asset_hdr_rec.book_type_code

Line 3075: fa_additions_b ad

3071: else
3072: select nvl(sum(salvage_value), 0)
3073: into px_asset_fin_rec_new.salvage_value
3074: from fa_books_mrc_v bk,
3075: fa_additions_b ad
3076: where bk.transaction_header_id_out is null
3077: and bk.group_asset_id = p_asset_hdr_rec.asset_id
3078: and bk.asset_id = ad.asset_id
3079: and bk.book_type_code = p_asset_hdr_rec.book_type_code