APPS.FA_AMORT_PVT dependencies on FA_CONVENTIONS

Line 7795: fa_conventions con

7791: AND ADJ.PERIOD_COUNTER_CREATED = p_period_rec.period_counter + 1
7792: AND ADJ.ADJUSTMENT_TYPE in ('RESERVE', 'EXPENSE')
7793: AND not exists ( select 1 from
7794: fa_retirements ret,
7795: fa_conventions con
7796: where th.transaction_type_code in (G_TRX_TYPE_FUL_RET, G_TRX_TYPE_PAR_RET)
7797: and ret.transaction_header_id_in = th.transaction_header_id
7798: and ret.asset_id = p_asset_hdr_rec.asset_id
7799: and ret.book_type_code = p_asset_hdr_rec.book_type_code

Line 7904: fa_conventions con

7900: AND ADJ.ADJUSTMENT_TYPE in ('RESERVE', 'EXPENSE')
7901: AND ADJ.SET_OF_BOOKS_ID = p_asset_hdr_rec.set_of_books_id
7902: AND not exists ( select 1 from
7903: fa_retirements ret,
7904: fa_conventions con
7905: where th.transaction_type_code in (G_TRX_TYPE_FUL_RET, G_TRX_TYPE_PAR_RET)
7906: and ret.transaction_header_id_in = th.transaction_header_id
7907: and ret.asset_id = p_asset_hdr_rec.asset_id
7908: and ret.book_type_code = p_asset_hdr_rec.book_type_code

Line 11950: fa_conventions con,

11946: th.invoice_transaction_id,
11947: '2nd SELECT in c_get_ths_adj'
11948: from fa_transaction_headers th,
11949: fa_retirements ret,
11950: fa_conventions con,
11951: fa_calendar_periods cp,
11952: fa_calendar_periods cptrx
11953: where th.asset_id = p_asset_hdr_rec.asset_id
11954: and th.book_type_code = p_asset_hdr_rec.book_type_code

Line 12415: from fa_conventions

12411: -- if the date falls in the prorate period and impact the catch-up.
12412: CURSOR c_get_prorate_date (c_date_placed_in_service date
12413: , c_prorate_convention_code varchar2) is
12414: select prorate_date, start_date, end_date
12415: from fa_conventions
12416: where prorate_convention_code = c_prorate_convention_code
12417: and c_date_placed_in_service between start_date and end_date;
12418:
12419: -- Bug6190904: Used with above cursor.

Line 12428: from fa_conventions con,

12424: -- Bug 8211842 : Get the prorated retirement date
12425: -- for a reinstatement transaction
12426: CURSOR c_get_retirement_pdate IS
12427: select decode(p_asset_fin_rec_old.group_asset_id, null, con.prorate_date, ret.date_retired) prorate_date
12428: from fa_conventions con,
12429: fa_retirements ret
12430: where ret.transaction_header_id_out = p_trans_rec.transaction_header_id
12431: and ret.book_type_code = p_asset_hdr_rec.book_type_code
12432: and ret.asset_id = p_asset_hdr_rec.asset_id

Line 13219: fa_conventions con

13215: fa_book_controls bc,
13216: fa_fiscal_year fy,
13217: fa_calendar_types ct,
13218: fa_retirements ret,
13219: fa_conventions con
13220: WHERE ret.book_type_code = p_asset_hdr_rec.book_type_code
13221: and ret.asset_id = p_asset_hdr_rec.asset_id
13222: and ret.transaction_header_id_in = l_trans_rec.transaction_header_id
13223: and ret.RETIREMENT_PRORATE_CONVENTION = con.PRORATE_CONVENTION_CODE

Line 13243: fa_conventions con

13239: INTO l_future_ret_count
13240: FROM fa_deprn_periods dp,
13241: fa_transaction_headers th,
13242: fa_retirements ret,
13243: fa_conventions con
13244: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
13245: and th.asset_id = p_asset_hdr_rec.asset_id
13246: and th.transaction_type_code like '%RETIREMENT'
13247: and th.date_effective between dp.period_open_date and dp.period_close_Date