DBA Data[Home] [Help]

APPS.IGI_IAC_YTD_PRE_PROCESS_PKG dependencies on FA_DEPRN_PERIODS

Line 29: and fdd.period_counter in (select period_counter from fa_deprn_periods

25: from fa_deprn_detail fdd
26: where fdd.distribution_id = cp_distribution_id
27: and fdd.book_type_code like cp_book_type_code
28: and fdd.asset_id = cp_asset_id
29: and fdd.period_counter in (select period_counter from fa_deprn_periods
30: where book_type_code = cp_book_type_code
31: and fiscal_year = (select decode(period_num,1,fiscal_year-1,fiscal_year)
32: from fa_deprn_periods
33: where period_close_date is NULL

Line 32: from fa_deprn_periods

28: and fdd.asset_id = cp_asset_id
29: and fdd.period_counter in (select period_counter from fa_deprn_periods
30: where book_type_code = cp_book_type_code
31: and fiscal_year = (select decode(period_num,1,fiscal_year-1,fiscal_year)
32: from fa_deprn_periods
33: where period_close_date is NULL
34: and book_type_code = cp_book_type_code))
35: group by fdd.asset_id,fdd.distribution_id;
36: