APPS.FA_GAINLOSS_UPD_PKG dependencies on FA_CATEGORY_BOOKS

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 1807: fa_category_books facb

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;
1811:

Line 3233: fa_category_books cb

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;
3237:

Line 3267: fa_category_books facb,

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
3271: and facb.book_type_code = h_book

Line 4271: fa_category_books facb,

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
4275: and facb.book_type_code = h_book

Line 4366: fa_category_books cb

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;
4370:

Line 4466: fa_category_books cb

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;
4470:

Line 4997: fa_category_books facb,

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
5001: and facb.book_type_code = h_book