APPS.FA_MASSCP_PKG dependencies on FA_ADDITIONS_B

Line 539: from fa_additions_b

535:
536: -- cat not in tax (handled in api but placing here to avoid fatal error)
537: select asset_category_id
538: into l_category_id
539: from fa_additions_b
540: where asset_id = p_asset_id;
541:
542: if not fa_cache_pkg.fazccb (
543: X_Book => p_tax_book,

Line 973: fa_additions_b ad,

969: (nvl(tax_bk.period_counter_life_complete,0)), 0),
970: tax_bk.group_asset_id
971: from fa_asset_history ah,
972: fa_transaction_headers corp_th,
973: fa_additions_b ad,
974: fa_books corp_bk_new,
975: fa_books corp_bk_old,
976: fa_books tax_bk
977: where corp_th.transaction_header_id = p_corp_thid

Line 1689: fa_additions_b ad,

1685: from fa_transaction_headers corp_th,
1686: fa_books corp_bk,
1687: fa_books tax_bk,
1688: fa_retirements corp_rt,
1689: fa_additions_b ad,
1690: fa_asset_history ah
1691: where corp_th.transaction_header_id = p_corp_thid
1692: and corp_th.asset_id = ah.asset_id
1693: and corp_th.date_effective < nvl(ah.date_ineffective,

Line 2613: fa_additions_b ad,

2609: books.date_placed_in_service,
2610: books.transaction_header_id_in,
2611: books.period_counter_fully_retired
2612: from fa_books books,
2613: fa_additions_b ad,
2614: fa_deprn_periods dp,
2615: fa_asset_history ah -- bug fix 5925965
2616: where books.date_effective <= nvl(l_corp_period_rec.period_close_date, sysdate)
2617: and nvl(books.date_ineffective, sysdate) > nvl(l_corp_period_rec.period_close_date, sysdate - 1)

Line 2723: from fa_additions_b ad,

2719: corp_th.transaction_header_id,
2720: corp_th.transaction_type_code,
2721: corp_bk_old.group_asset_id old_group_asset_id,
2722: corp_bk.group_asset_id new_group_asset_id
2723: from fa_additions_b ad,
2724: fa_transaction_headers corp_th,
2725: fa_books corp_bk,
2726: fa_books corp_bk_old,
2727: TABLE(CAST(fa_trx_types_tab AS fa_char30_tbl_type)) trx