DBA Data[Home] [Help]

APPS.FARX_C_WD dependencies on FA_BOOK_CONTROLS

Line 197: from fa_book_controls

193:
194: end if;
195:
196: select count(*) into h_count
197: from fa_book_controls
198: where book_Type_code = argument1 and rownum < 2;
199:
200: if h_count = 0 then
201: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');

Line 242: from fa_book_controls bc, fa_calendar_periods cp

238: end if;
239:
240: h_count := 0;
241: select count(*) into h_count
242: from fa_book_controls bc, fa_calendar_periods cp
243: where bc.book_type_code = argument1
244: and bc.deprn_calendar = cp.calendar_type
245: and cp.period_name = argument2 and rownum < 2;
246:

Line 276: from fa_book_controls bc, fa_calendar_types ct,

272:
273: -- Make sure calendar is defined for duration of projection.
274:
275: select count(*) into h_count
276: from fa_book_controls bc, fa_calendar_types ct,
277: fa_calendar_periods cp
278: where bc.book_type_code = argument1
279: and bc.deprn_calendar = ct.calendar_type
280: and ct.calendar_type = cp.calendar_type