DBA Data[Home] [Help]

APPS.FARX_C_WD dependencies on FA_CALENDAR_PERIODS

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 303: fa_calendar_periods cp

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
307: and cp.start_date >= (select cp1.start_date from

Line 308: fa_calendar_periods cp1

304: where bc.book_type_code = argument1
305: and bc.deprn_calendar = ct.calendar_type
306: and ct.calendar_type = cp.calendar_type
307: and cp.start_date >= (select cp1.start_date from
308: fa_calendar_periods cp1
309: where cp1.calendar_type = cp.calendar_type
310: and cp1.period_name = argument2);
311:
312: if h_count < to_number(argument3) then