DBA Data[Home] [Help]

APPS.FA_MASSCP_PKG dependencies on FA_ADDITIONS_B

Line 767: from fa_additions_b

763:
764: -- cat not in tax (handled in api but placing here to avoid fatal error)
765: select asset_category_id
766: into l_category_id
767: from fa_additions_b
768: where asset_id = p_asset_id;
769:
770: if not fa_cache_pkg.fazccb (
771: X_Book => p_tax_book,

Line 1227: fa_additions_b ad,

1223: (nvl(tax_bk.period_counter_life_complete,0)), 0),
1224: tax_bk.group_asset_id
1225: from fa_asset_history ah,
1226: fa_transaction_headers corp_th,
1227: fa_additions_b ad,
1228: fa_books corp_bk_new,
1229: fa_books corp_bk_old,
1230: fa_books tax_bk
1231: where corp_th.transaction_header_id = p_corp_thid

Line 1983: fa_additions_b ad,

1979: from fa_transaction_headers corp_th,
1980: fa_books corp_bk,
1981: fa_books tax_bk,
1982: fa_retirements corp_rt,
1983: fa_additions_b ad,
1984: fa_asset_history ah
1985: where corp_th.transaction_header_id = p_corp_thid
1986: and corp_th.asset_id = ah.asset_id
1987: and corp_th.date_effective < nvl(ah.date_ineffective,

Line 2939: fa_additions_b ad,

2935: books.date_placed_in_service,
2936: books.transaction_header_id_in,
2937: books.period_counter_fully_retired
2938: from fa_books books,
2939: fa_additions_b ad,
2940: fa_deprn_periods dp,
2941: fa_asset_history ah -- bug fix 5900321
2942: where books.date_effective <= nvl(l_corp_period_rec.period_close_date, sysdate)
2943: and nvl(books.date_ineffective, sysdate) > nvl(l_corp_period_rec.period_close_date, sysdate - 1)

Line 3049: from fa_additions_b ad,

3045: corp_th.transaction_header_id,
3046: corp_th.transaction_type_code,
3047: corp_bk_old.group_asset_id old_group_asset_id,
3048: corp_bk.group_asset_id new_group_asset_id
3049: from fa_additions_b ad,
3050: fa_transaction_headers corp_th,
3051: fa_books corp_bk,
3052: fa_books corp_bk_old,
3053: TABLE(CAST(fa_trx_types_tab AS fa_char30_tbl_type)) trx