APPS.FA_RECLASS_UTIL_PVT dependencies on FA_DEPRN_PERIODS

Line 334: FA_DEPRN_PERIODS DP_NOW,

330: h_mesg_name := 'FA_REC_SQL_PRIOR_PER';
331:
332: select count(1)
333: into v_is_prior_period
334: FA_DEPRN_PERIODS DP_NOW,
335: FA_DEPRN_PERIODS DP,
336: FA_BOOK_CONTROLS BC,
337: FA_TRANSACTION_HEADERS TH
338: WHERE

Line 335: FA_DEPRN_PERIODS DP,

331:
332: select count(1)
333: into v_is_prior_period
334: FA_DEPRN_PERIODS DP_NOW,
335: FA_DEPRN_PERIODS DP,
336: FA_BOOK_CONTROLS BC,
337: FA_TRANSACTION_HEADERS TH
338: WHERE
339: TH.ASSET_ID = p_asset_id AND

Line 420: FROM FA_DEPRN_PERIODS pdp, FA_DEPRN_PERIODS adp

416: FETCH get_prior_date_effective INTO l_prior_date_effective;
417: CLOSE get_prior_date_effective;
418:
419: SELECT count(1) INTO l_check_another_trans
420: FROM FA_DEPRN_PERIODS pdp, FA_DEPRN_PERIODS adp
421: WHERE pdp.book_type_code = p_book
422: AND pdp.book_type_code = adp.book_type_code
423: AND pdp.period_counter > adp.period_counter
424: AND l_prior_date_effective between pdp.period_open_date

Line 789: FROM fa_deprn_periods dp

785: -- fix for bug 3255715
786: CURSOR trx_date_csr( p_book varchar2) IS
787: SELECT greatest(dp.calendar_period_open_date,
788: least(sysdate, dp.calendar_period_close_date))
789: FROM fa_deprn_periods dp
790: WHERE dp.book_type_code = p_book
791: AND dp.period_close_date IS NULL;
792:
793: i integer:= 0;