DBA Data[Home] [Help]

APPS.FA_AMORT_PVT dependencies on FA_CONVENTIONS

Line 11477: fa_conventions con,

11473: th.invoice_transaction_id,
11474: '2nd SELECT in c_get_ths_adj'
11475: from fa_transaction_headers th,
11476: fa_retirements ret,
11477: fa_conventions con,
11478: fa_calendar_periods cp,
11479: fa_calendar_periods cptrx
11480: where th.asset_id = p_asset_hdr_rec.asset_id
11481: and th.book_type_code = p_asset_hdr_rec.book_type_code

Line 11841: from fa_conventions

11837: -- if the date falls in the prorate period and impact the catch-up.
11838: CURSOR c_get_prorate_date (c_date_placed_in_service date
11839: , c_prorate_convention_code varchar2) is
11840: select prorate_date, start_date, end_date
11841: from fa_conventions
11842: where prorate_convention_code = c_prorate_convention_code
11843: and c_date_placed_in_service between start_date and end_date;
11844:
11845: -- Bug6190904: Used with above cursor.