APPS.FA_AMORT_PVT dependencies on FA_CALENDAR_PERIODS

Line 150: from fa_calendar_periods

146:
147: CURSOR c_get_period_info IS
148: select start_date
149: , end_date
150: from fa_calendar_periods
151: where calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
152: and to_date (to_char (p_jdate), 'J') between start_date
153: and end_date;
154:

Line 330: , fa_calendar_periods cp

326: , 'N'
327: from fa_book_controls bc
328: , fa_fiscal_year fy
329: , fa_calendar_types ct
330: , fa_calendar_periods cp
331: where bc.book_type_code = p_asset_hdr_rec.book_type_code
332: and bc.deprn_calendar = ct.calendar_type
333: and bc.fiscal_year_name = fy.fiscal_year_name
334: and ct.fiscal_year_name = bc.fiscal_year_name

Line 993: , fa_calendar_periods cp

989: , fy.fiscal_year fiscal_year
990: , 'N'
991: from fa_fiscal_year fy
992: , fa_calendar_types ct
993: , fa_calendar_periods cp
994: where ct.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
995: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
996: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
997: and ct.calendar_type = cp.calendar_type

Line 11478: fa_calendar_periods cp,

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
11482: and ret.asset_id = p_asset_hdr_rec.asset_id

Line 11479: fa_calendar_periods cptrx

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
11482: and ret.asset_id = p_asset_hdr_rec.asset_id
11483: and ret.book_type_code = p_asset_hdr_rec.book_type_code