APPS.FARX_C_WD dependencies on FA_CALENDAR_PERIODS

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

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

Line 282: fa_calendar_periods cp1

278: where bc.book_type_code = argument1
279: and bc.deprn_calendar = ct.calendar_type
280: and ct.calendar_type = cp.calendar_type
281: and cp.start_date >= (select cp1.start_date from
282: fa_calendar_periods cp1
283: where cp1.calendar_type = cp.calendar_type
284: and cp1.period_name = argument2);
285:
286: if h_count < to_number(argument3) then