APPS.FARX_TF dependencies on FA_DEPRN_PERIODS

Line 212: from fa_deprn_periods

208: h_mesg_name := 'FA_AMT_SEL_PERIODS';
209:
210: select period_open_date
211: into h_period1_pod
212: from fa_deprn_periods
213: where book_type_code = h_book and period_name = begin_period;
214:
215: select count(*) into h_count
216: from fa_deprn_periods where period_name = end_period

Line 216: from fa_deprn_periods where period_name = end_period

212: from fa_deprn_periods
213: where book_type_code = h_book and period_name = begin_period;
214:
215: select count(*) into h_count
216: from fa_deprn_periods where period_name = end_period
217: and book_type_code = h_book;
218:
219: if (h_count > 0) then
220: select period_close_date

Line 222: from fa_deprn_periods

218:
219: if (h_count > 0) then
220: select period_close_date
221: into h_period2_pcd
222: from fa_deprn_periods
223: where book_type_code = h_book and period_name = end_period;
224: else
225: h_period2_pcd := null;
226: end if;