APPS.FA_GAINLOSS_UPD_PKG dependencies on FA_ADDITIONS_B

Line 869: fa_additions_b ad, fa_category_books cb

865: h_reval_rsv_retired_loss_acct,
866: h_retire_reval_flag,
867: l_asset_cat_rec_m.category_id
868: from fa_book_controls bc,
869: fa_additions_b ad, fa_category_books cb
870: where ad.asset_id = h_asset_id
871: and cb.category_id = ad.asset_category_id
872: and cb.book_type_code = h_book
873: and bc.book_type_code = cb.book_type_code;

Line 2009: from fa_additions_b faadd,

2005: select asset_cost_acct,
2006: nvl(cip_cost_acct, '0')
2007: into h_asset_cost_acct,
2008: h_cip_cost_acct
2009: from fa_additions_b faadd,
2010: fa_category_books facb
2011: where faadd.asset_id = h_asset_id
2012: and facb.category_id = faadd.asset_category_id
2013: and facb.book_type_code = h_book;

Line 4116: from fa_additions_b ad,

4112: elsif adj_type = 'BONUS EXPENSE' then
4113:
4114: select nvl(cb.bonus_deprn_expense_acct,'0')
4115: into h_bonus_deprn_exp_acct
4116: from fa_additions_b ad,
4117: fa_category_books cb
4118: where ad.asset_id = h_asset_id
4119: and cb.category_id = ad.asset_category_id
4120: and cb.book_type_code = h_book;

Line 4132: from fa_additions_b ad,

4128: elsif adj_type = 'IMPAIR EXPENSE' then
4129:
4130: select nvl(cb.impair_expense_acct,'0')
4131: into h_impair_exp_acct
4132: from fa_additions_b ad,
4133: fa_category_books cb
4134: where ad.asset_id = h_asset_id
4135: and cb.category_id = ad.asset_category_id
4136: and cb.book_type_code = h_book;

Line 4166: from fa_additions_b faadd,

4162: */
4163:
4164: select facb.deprn_expense_acct
4165: into h_deprn_exp_acct
4166: from fa_additions_b faadd,
4167: fa_category_books facb,
4168: fa_book_controls bc
4169: where faadd.asset_id = h_asset_id
4170: and facb.category_id = faadd.asset_category_id

Line 5622: from fa_additions_b faadd,

5618: */
5619:
5620: select facb.deprn_expense_acct
5621: into h_deprn_exp_acct
5622: from fa_additions_b faadd,
5623: fa_category_books facb,
5624: fa_book_controls bc
5625: where faadd.asset_id = h_asset_id
5626: and facb.category_id = faadd.asset_category_id

Line 5738: from fa_additions_b ad,

5734:
5735: if bonus_deprn_amt <> 0 then
5736: select nvl(cb.bonus_deprn_expense_acct,'0')
5737: into h_bonus_deprn_exp_acct
5738: from fa_additions_b ad,
5739: fa_category_books cb
5740: where ad.asset_id = h_asset_id
5741: and cb.category_id = ad.asset_category_id
5742: and cb.book_type_code = h_book;

Line 5771: from fa_additions_b ad,

5767:
5768: if impairment_amt <> 0 then
5769: select nvl(cb.impair_expense_acct,'0')
5770: into h_impair_exp_acct
5771: from fa_additions_b ad,
5772: fa_category_books cb
5773: where ad.asset_id = h_asset_id
5774: and cb.category_id = ad.asset_category_id
5775: and cb.book_type_code = h_book;

Line 5889: from fa_additions_b ad,

5885: if bonus_deprn_amt <> 0 then
5886:
5887: select nvl(cb.bonus_deprn_expense_acct,'0')
5888: into h_bonus_deprn_exp_acct
5889: from fa_additions_b ad,
5890: fa_category_books cb
5891: where ad.asset_id = h_asset_id
5892: and cb.category_id = ad.asset_category_id
5893: and cb.book_type_code = h_book;

Line 5923: from fa_additions_b ad,

5919: if impairment_amt <> 0 then
5920:
5921: select nvl(cb.impair_expense_acct,'0')
5922: into h_impair_exp_acct
5923: from fa_additions_b ad,
5924: fa_category_books cb
5925: where ad.asset_id = h_asset_id
5926: and cb.category_id = ad.asset_category_id
5927: and cb.book_type_code = h_book;

Line 6591: from fa_additions_b faadd,

6587: h_reval_rsv_acct,
6588: h_bonus_deprn_rsv_acct,
6589: h_impairment_rsv_acct,
6590: h_retire_reval_flag
6591: from fa_additions_b faadd,
6592: fa_category_books facb,
6593: fa_book_controls bc
6594: where faadd.asset_id = h_asset_id
6595: and facb.category_id = faadd.asset_category_id