eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_FAS445_XMLP_PKG dependencies on FA_BOOK_CONTROLS

Line 102: FROM FA_BOOK_CONTROLS bc,

98: SELECT
99: cur.precision
100: INTO
101: l_precision
102: FROM FA_BOOK_CONTROLS bc,
103: GL_SETS_OF_BOOKS sob,
104: FND_CURRENCIES cur
105: WHERE bc.book_type_code = P_BOOK
106: AND sob.set_of_books_id = bc.set_of_books_id

Line 201: fa_book_controls bc

197: l_fiscal_year_name varchar2(30);
198: cursor c_end is
199: select period_num, cp.start_date, fiscal_year_name
200: from fa_calendar_periods cp,
201: fa_book_controls bc
202: where calendar_type = bc.deprn_calendar
203: and bc.book_type_code = x_book
204: and start_date >= previous_end_date
205: order by start_date;

Line 316: from fa_book_controls bc, fa_calendar_types ct

312: select bc.deprn_calendar,
313: bc.fiscal_year_name,
314: ct.number_per_fiscal_year
315: into h_calendar_type, h_fy_name, h_num_per_fy
316: from fa_book_controls bc, fa_calendar_types ct
317: where bc.book_type_code = X_book
318: and bc.deprn_calendar = ct.calendar_type;
319: dpr_in.calendar_type := h_calendar_type;
320: dpr_in.jdate_retired := 0;

Line 379: fa_book_controls bc

375: dpr_in.y_begin := h_prorate_start_year;
376: select period_num
377: into dpr_in.p_cl_begin
378: from fa_calendar_periods cp,
379: fa_book_controls bc
380: where calendar_type = bc.deprn_calendar
381: and bc.book_type_code = x_book
382: and dpr_in.prorate_date
383: between cp.start_date and cp.end_date;

Line 389: fa_book_controls bc

385: dpr_in.y_end := 1961;
386: select period_num
387: into dpr_in.p_cl_end
388: from fa_calendar_periods cp,
389: fa_book_controls bc
390: where calendar_type = bc.deprn_calendar
391: and bc.book_type_code = x_book
392: and to_date('19611231','YYYYMMDD')
393: between cp.start_date and cp.end_date;

Line 400: fa_book_controls bc

396: dpr_in.y_end := l_date_retired_year;
397: select period_num
398: into dpr_in.p_cl_end
399: from fa_calendar_periods cp,
400: fa_book_controls bc
401: where calendar_type = bc.deprn_calendar
402: and bc.book_type_code = x_book
403: and l_date_retired
404: between cp.start_date and cp.end_date;

Line 430: fa_book_controls bc

426: dpr_in.y_end := 1961;
427: select period_num
428: into dpr_in.p_cl_end
429: from fa_calendar_periods cp,
430: fa_book_controls bc
431: where calendar_type = bc.deprn_calendar
432: and bc.book_type_code = x_book
433: and to_date('19611231','YYYYMMDD')
434: between cp.start_date and cp.end_date;

Line 441: fa_book_controls bc

437: dpr_in.y_end := l_date_retired_year;
438: select period_num
439: into dpr_in.p_cl_end
440: from fa_calendar_periods cp,
441: fa_book_controls bc
442: where calendar_type = bc.deprn_calendar
443: and bc.book_type_code = x_book
444: and l_date_retired
445: between cp.start_date and cp.end_date;

Line 688: fa_book_controls bc

684: l_fiscal_year_name varchar2(30);
685: cursor c_end is
686: select period_num, cp.start_date, fiscal_year_name
687: from fa_calendar_periods cp,
688: fa_book_controls bc
689: where calendar_type = bc.deprn_calendar
690: and bc.book_type_code = x_book
691: and start_date >= previous_end_date
692: order by start_date;

Line 807: from fa_book_controls bc, fa_calendar_types ct

803: select bc.deprn_calendar,
804: bc.fiscal_year_name,
805: ct.number_per_fiscal_year
806: into h_calendar_type, h_fy_name, h_num_per_fy
807: from fa_book_controls bc, fa_calendar_types ct
808: where bc.book_type_code = X_book
809: and bc.deprn_calendar = ct.calendar_type;
810: dpr_in.calendar_type := h_calendar_type;
811: dpr_in.jdate_retired := 0;

Line 870: fa_book_controls bc

866: dpr_in.y_begin := h_prorate_start_year;
867: select period_num
868: into dpr_in.p_cl_begin
869: from fa_calendar_periods cp,
870: fa_book_controls bc
871: where calendar_type = bc.deprn_calendar
872: and bc.book_type_code = x_book
873: and dpr_in.prorate_date
874: between cp.start_date and cp.end_date;

Line 880: fa_book_controls bc

876: dpr_in.y_end := 1969;
877: select period_num
878: into dpr_in.p_cl_end
879: from fa_calendar_periods cp,
880: fa_book_controls bc
881: where calendar_type = bc.deprn_calendar
882: and bc.book_type_code = x_book
883: and to_date('19691231','YYYYMMDD')
884: between cp.start_date and cp.end_date;

Line 891: fa_book_controls bc

887: dpr_in.y_end := l_date_retired_year;
888: select period_num
889: into dpr_in.p_cl_end
890: from fa_calendar_periods cp,
891: fa_book_controls bc
892: where calendar_type = bc.deprn_calendar
893: and bc.book_type_code = x_book
894: and l_date_retired
895: between cp.start_date and cp.end_date;

Line 915: fa_book_controls bc

911: dpr_in.y_end := 1969;
912: select period_num
913: into dpr_in.p_cl_end
914: from fa_calendar_periods cp,
915: fa_book_controls bc
916: where calendar_type = bc.deprn_calendar
917: and bc.book_type_code = x_book
918: and to_date('19691231','YYYYMMDD')
919: between cp.start_date and cp.end_date;

Line 926: fa_book_controls bc

922: dpr_in.y_end := l_date_retired_year;
923: select period_num
924: into dpr_in.p_cl_end
925: from fa_calendar_periods cp,
926: fa_book_controls bc
927: where calendar_type = bc.deprn_calendar
928: and bc.book_type_code = x_book
929: and l_date_retired
930: between cp.start_date and cp.end_date;