DBA Data[Home] [Help]

APPS.FARX_AJ dependencies on FA_DEPRN_PERIODS

Line 233: from fa_deprn_periods

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

Line 237: from fa_deprn_periods where period_name = end_period

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

Line 243: from fa_deprn_periods

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

Line 559: from fa_deprn_periods

555: h_mesg_name := 'FA_AMT_SEL_PERIODS';
556:
557: select period_open_date, period_close_date
558: into h_period1_pod, h_period1_pcd
559: from fa_deprn_periods
560: where book_type_code = h_book and period_name = period;
561:
562: h_mesg_name := 'FA_REC_SQL_ACCT_FLEX';
563: