APPS.FA_GAINLOSS_UPD_PKG dependencies on FA_ADDITIONS_B

Line 809: fa_additions_b ad, fa_category_books cb

805: h_reval_rsv_retired_loss_acct,
806: h_retire_reval_flag,
807: l_asset_cat_rec_m.category_id
808: from fa_book_controls bc,
809: fa_additions_b ad, fa_category_books cb
810: where ad.asset_id = h_asset_id
811: and cb.category_id = ad.asset_category_id
812: and cb.book_type_code = h_book
813: and bc.book_type_code = cb.book_type_code;

Line 1806: from fa_additions_b faadd,

1802: select asset_cost_acct,
1803: nvl(cip_cost_acct, '0')
1804: into h_asset_cost_acct,
1805: h_cip_cost_acct
1806: from fa_additions_b faadd,
1807: fa_category_books facb
1808: where faadd.asset_id = h_asset_id
1809: and facb.category_id = faadd.asset_category_id
1810: and facb.book_type_code = h_book;

Line 3232: from fa_additions_b ad,

3228: elsif adj_type = 'BONUS EXPENSE' then
3229:
3230: select nvl(cb.bonus_deprn_expense_acct,'0')
3231: into h_bonus_deprn_exp_acct
3232: from fa_additions_b ad,
3233: fa_category_books cb
3234: where ad.asset_id = h_asset_id
3235: and cb.category_id = ad.asset_category_id
3236: and cb.book_type_code = h_book;

Line 3266: from fa_additions_b faadd,

3262: */
3263:
3264: select facb.deprn_expense_acct
3265: into h_deprn_exp_acct
3266: from fa_additions_b faadd,
3267: fa_category_books facb,
3268: fa_book_controls bc
3269: where faadd.asset_id = h_asset_id
3270: and facb.category_id = faadd.asset_category_id

Line 4270: from fa_additions_b faadd,

4266: */
4267:
4268: select facb.deprn_expense_acct
4269: into h_deprn_exp_acct
4270: from fa_additions_b faadd,
4271: fa_category_books facb,
4272: fa_book_controls bc
4273: where faadd.asset_id = h_asset_id
4274: and facb.category_id = faadd.asset_category_id

Line 4365: from fa_additions_b ad,

4361:
4362: if bonus_deprn_amt <> 0 then
4363: select nvl(cb.bonus_deprn_expense_acct,'0')
4364: into h_bonus_deprn_exp_acct
4365: from fa_additions_b ad,
4366: fa_category_books cb
4367: where ad.asset_id = h_asset_id
4368: and cb.category_id = ad.asset_category_id
4369: and cb.book_type_code = h_book;

Line 4465: from fa_additions_b ad,

4461: if bonus_deprn_amt <> 0 then
4462:
4463: select nvl(cb.bonus_deprn_expense_acct,'0')
4464: into h_bonus_deprn_exp_acct
4465: from fa_additions_b ad,
4466: fa_category_books cb
4467: where ad.asset_id = h_asset_id
4468: and cb.category_id = ad.asset_category_id
4469: and cb.book_type_code = h_book;

Line 4996: from fa_additions_b faadd,

4992: into h_deprn_rsv_acct,
4993: h_reval_rsv_acct,
4994: h_bonus_deprn_rsv_acct,
4995: h_retire_reval_flag
4996: from fa_additions_b faadd,
4997: fa_category_books facb,
4998: fa_book_controls bc
4999: where faadd.asset_id = h_asset_id
5000: and facb.category_id = faadd.asset_category_id