APPS.FA_FAS443_XMLP_PKG dependencies on FA_BOOK_CONTROLS

Line 25: FROM FA_BOOK_CONTROLS bc,

21: l_accounting_flex_Structure,
22: l_distribution_source_book,
23: l_currency_code,
24: l_precision
25: FROM FA_BOOK_CONTROLS bc,
26: GL_SETS_OF_BOOKS sob,
27: FND_CURRENCIES cur
28: WHERE bc.book_type_code = P_BOOK
29: AND sob.set_of_books_id = bc.set_of_books_id

Line 222: fa_book_controls bc

218: l_fiscal_year_name fa_fiscal_year.fiscal_year_name%type;
219: cursor c_end is
220: select period_num, cp.start_date, fiscal_year_name
221: from fa_calendar_periods cp,
222: fa_book_controls bc
223: where calendar_type = bc.deprn_calendar
224: and bc.book_type_code = x_book
225: and start_date >= previous_end_date
226: order by start_date;

Line 335: from fa_book_controls bc, fa_calendar_types ct

331: select bc.deprn_calendar,
332: bc.fiscal_year_name,
333: ct.number_per_fiscal_year
334: into h_calendar_type, h_fy_name, h_num_per_fy
335: from fa_book_controls bc, fa_calendar_types ct
336: where bc.book_type_code = X_book
337: and bc.deprn_calendar = ct.calendar_type;
338: dpr_in.calendar_type := h_calendar_type;
339: dpr_in.jdate_retired := 0;

Line 396: fa_book_controls bc

392: dpr_in.y_begin := h_prorate_start_year;
393: select period_num
394: into dpr_in.p_cl_begin
395: from fa_calendar_periods cp,
396: fa_book_controls bc
397: where calendar_type = bc.deprn_calendar
398: and bc.book_type_code = x_book
399: and dpr_in.prorate_date
400: between cp.start_date and cp.end_date;

Line 413: fa_book_controls bc

409: dpr_in.y_end := l_date_retired_year;
410: select period_num
411: into dpr_in.p_cl_end
412: from fa_calendar_periods cp,
413: fa_book_controls bc
414: where calendar_type = bc.deprn_calendar
415: and bc.book_type_code = x_book
416: and l_date_retired
417: between cp.start_date and cp.end_date;

Line 435: fa_book_controls bc

431: dpr_in.y_end := 1961;
432: select period_num
433: into dpr_in.p_cl_end
434: from fa_calendar_periods cp,
435: fa_book_controls bc
436: where calendar_type = bc.deprn_calendar
437: and bc.book_type_code = x_book
438: and to_date('19611231','YYYYMMDD')
439: between cp.start_date and cp.end_date;

Line 446: fa_book_controls bc

442: dpr_in.y_end := l_date_retired_year;
443: select period_num
444: into dpr_in.p_cl_end
445: from fa_calendar_periods cp,
446: fa_book_controls bc
447: where calendar_type = bc.deprn_calendar
448: and bc.book_type_code = x_book
449: and l_date_retired
450: between cp.start_date and cp.end_date;