DBA Data[Home] [Help]

APPS.FA_AMORT_PVT dependencies on FA_BOOK_CONTROLS_MRC_V

Line 8055: fa_book_controls_mrc_v bc,

8051: nvl(sum(ret.eofy_reserve), 0)
8052: from fa_retirements_mrc_v ret,
8053: fa_transaction_headers mth,
8054: fa_transaction_headers gth,
8055: fa_book_controls_mrc_v bc,
8056: fa_fiscal_year fy
8057: where gth.asset_id = p_asset_hdr_rec.asset_id
8058: and gth.book_type_code = p_asset_hdr_rec.book_type_code
8059: and bc.book_type_code = p_asset_hdr_rec.book_type_code

Line 8073: fa_book_controls_mrc_v bc

8069: and ret.transaction_header_id_out is null
8070: and fy.start_date =
8071: (select fy.start_date
8072: from fa_fiscal_year fy,
8073: fa_book_controls_mrc_v bc
8074: where bc.book_type_code = p_asset_hdr_rec.book_type_code
8075: and bc.fiscal_year_name = fy.fiscal_year_name
8076: and fy.start_date <= p_trans_rec.transaction_date_entered
8077: and fy.end_date >= p_trans_rec.transaction_date_entered