APPS.FA_RECLASS_UTIL_PVT dependencies on FA_DEPRN_PERIODS

Line 351: FA_DEPRN_PERIODS DP_NOW,

347: h_mesg_name := 'FA_REC_SQL_PRIOR_PER';
348:
349: select count(1)
350: into v_is_prior_period
351: FA_DEPRN_PERIODS DP_NOW,
352: FA_DEPRN_PERIODS DP,
353: FA_BOOK_CONTROLS BC,
354: FA_TRANSACTION_HEADERS TH
355: WHERE

Line 352: FA_DEPRN_PERIODS DP,

348:
349: select count(1)
350: into v_is_prior_period
351: FA_DEPRN_PERIODS DP_NOW,
352: FA_DEPRN_PERIODS DP,
353: FA_BOOK_CONTROLS BC,
354: FA_TRANSACTION_HEADERS TH
355: WHERE
356: TH.ASSET_ID = p_asset_id AND

Line 440: FROM FA_DEPRN_PERIODS pdp, FA_DEPRN_PERIODS adp

436: FETCH get_prior_date_effective INTO l_prior_date_effective;
437: CLOSE get_prior_date_effective;
438:
439: SELECT count(1) INTO l_check_another_trans
440: FROM FA_DEPRN_PERIODS pdp, FA_DEPRN_PERIODS adp
441: WHERE pdp.book_type_code = p_book
442: AND pdp.book_type_code = adp.book_type_code
443: AND pdp.period_counter > adp.period_counter
444: AND l_prior_date_effective between pdp.period_open_date

Line 825: FROM fa_deprn_periods dp

821: -- fix for bug 3255715
822: CURSOR trx_date_csr( p_book varchar2) IS
823: SELECT greatest(dp.calendar_period_open_date,
824: least(sysdate, dp.calendar_period_close_date))
825: FROM fa_deprn_periods dp
826: WHERE dp.book_type_code = p_book
827: AND dp.period_close_date IS NULL;
828:
829: i integer:= 0;