DBA Data[Home] [Help]

APPS.FA_ASSET_CALC_PVT dependencies on FA_CALENDAR_PERIODS

Line 3114: from fa_calendar_periods cp,

3110:
3111: select /*+ leading(conv) use_nl(conv cp) index(cp) */
3112: prorate_date
3113: into px_asset_fin_rec_new.prorate_date
3114: from fa_calendar_periods cp,
3115: fa_conventions conv
3116: where conv.prorate_convention_code = px_asset_fin_rec_new.prorate_convention_code
3117: and conv.start_date <= px_asset_fin_rec_new.date_placed_in_service
3118: and conv.end_date >= px_asset_fin_rec_new.date_placed_in_service

Line 3956: from fa_calendar_periods cp,

3952: (decode (bc.deprn_allocation_code,'E',
3953: 1/ct.number_per_fiscal_year,
3954: (cp.end_date + 1 - cp.start_date) /
3955: (fy.end_date + 1 - fy.start_date))),0) * 12, 0)
3956: from fa_calendar_periods cp,
3957: fa_calendar_types ct,
3958: fa_book_controls bc,
3959: fa_fiscal_year fy
3960: where bc.book_type_code = p_asset_hdr_rec.book_type_code