APPS.FA_REC_PVT_PKG1 dependencies on FA_DEPRN_PERIODS

Line 348: FROM FA_DEPRN_PERIODS pdp, FA_DEPRN_PERIODS adp

344: FETCH get_prior_date_effective INTO prior_date_effective;
345: CLOSE get_prior_date_effective;
346:
347: SELECT count(1) INTO check_another_trans
348: FROM FA_DEPRN_PERIODS pdp, FA_DEPRN_PERIODS adp
349: WHERE pdp.book_type_code = p_book_type_code
350: AND pdp.book_type_code = adp.book_type_code
351: AND pdp.period_counter > adp.period_counter
352: AND prior_date_effective between pdp.period_open_date