DBA Data[Home] [Help]

APPS.FARX_C_WD dependencies on FA_BOOK_CONTROLS

Line 223: from fa_book_controls

219:
220: end if;
221:
222: select count(*) into h_count
223: from fa_book_controls
224: where book_Type_code = argument1 and rownum < 2;
225:
226: if h_count = 0 then
227: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');

Line 268: from fa_book_controls bc, fa_calendar_periods cp

264: end if;
265:
266: h_count := 0;
267: select count(*) into h_count
268: from fa_book_controls bc, fa_calendar_periods cp
269: where bc.book_type_code = argument1
270: and bc.deprn_calendar = cp.calendar_type
271: and cp.period_name = argument2 and rownum < 2;
272:

Line 302: from fa_book_controls bc, fa_calendar_types ct,

298:
299: -- Make sure calendar is defined for duration of projection.
300:
301: select count(*) into h_count
302: from fa_book_controls bc, fa_calendar_types ct,
303: fa_calendar_periods cp
304: where bc.book_type_code = argument1
305: and bc.deprn_calendar = ct.calendar_type
306: and ct.calendar_type = cp.calendar_type