DBA Data[Home] [Help]

APPS.FA_REC_PVT_PKG1 dependencies on FA_DEPRN_PERIODS

Line 328: FROM FA_DEPRN_PERIODS pdp, FA_DEPRN_PERIODS adp

324: FETCH get_prior_date_effective INTO prior_date_effective;
325: CLOSE get_prior_date_effective;
326:
327: SELECT count(1) INTO check_another_trans
328: FROM FA_DEPRN_PERIODS pdp, FA_DEPRN_PERIODS adp
329: WHERE pdp.book_type_code = p_book_type_code
330: AND pdp.book_type_code = adp.book_type_code
331: AND pdp.period_counter > adp.period_counter
332: AND prior_date_effective between pdp.period_open_date