DBA Data[Home] [Help]

APPS.FARX_AJ dependencies on FA_DEPRN_PERIODS

Line 234: from fa_deprn_periods

230: where book_type_code=h_book;
231:
232: select period_open_date
233: into h_period1_pod
234: from fa_deprn_periods
235: where book_type_code = h_book and period_name = begin_period;
236:
237: select count(*) into h_count
238: from fa_deprn_periods where period_name = end_period

Line 238: from fa_deprn_periods where period_name = end_period

234: from fa_deprn_periods
235: where book_type_code = h_book and period_name = begin_period;
236:
237: select count(*) into h_count
238: from fa_deprn_periods where period_name = end_period
239: and book_type_code = h_book;
240:
241: if (h_count > 0) then
242: select period_close_date

Line 244: from fa_deprn_periods

240:
241: if (h_count > 0) then
242: select period_close_date
243: into h_period2_pcd
244: from fa_deprn_periods
245: where book_type_code = h_book and period_name = end_period;
246: else
247: h_period2_pcd := null;
248: end if;

Line 987: from fa_deprn_periods

983: h_mesg_name := 'FA_AMT_SEL_PERIODS';
984:
985: select period_open_date, period_close_date
986: into h_period1_pod, h_period1_pcd
987: from fa_deprn_periods
988: where book_type_code = h_book and period_name = period;
989:
990: h_mesg_name := 'FA_REC_SQL_ACCT_FLEX';
991: