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_TOFES_YUD_ALEF_PKG dependencies on FA_DEPRN_PERIODS

Line 192: FROM FA_DEPRN_PERIODS_MRC_V fdp

188: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
189: AND ASSET_ID = p_asset_id_in
190: AND period_counter = p_period_counter
191: AND PERIOD_COUNTER > (SELECT MAX(fdp.period_counter)
192: FROM FA_DEPRN_PERIODS_MRC_V fdp
193: WHERE FDP.book_type_code = P_BOOK_NAME
194: AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
195: FROM FA_DEPRN_PERIODS_MRC_V
196: WHERE book_type_code = P_BOOK_NAME

Line 195: FROM FA_DEPRN_PERIODS_MRC_V

191: AND PERIOD_COUNTER > (SELECT MAX(fdp.period_counter)
192: FROM FA_DEPRN_PERIODS_MRC_V fdp
193: WHERE FDP.book_type_code = P_BOOK_NAME
194: AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
195: FROM FA_DEPRN_PERIODS_MRC_V
196: WHERE book_type_code = P_BOOK_NAME
197: AND period_close_date IS NOT NULL));
198: ELSE
199:

Line 207: FROM fa_deprn_periods fdp

203: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
204: AND ASSET_ID = p_asset_id_in
205: AND period_counter = p_period_counter
206: AND PERIOD_COUNTER > (SELECT MAX(fdp.period_counter)
207: FROM fa_deprn_periods fdp
208: WHERE FDP.book_type_code = P_BOOK_NAME
209: AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
210: FROM FA_DEPRN_PERIODS
211: WHERE book_type_code = P_BOOK_NAME

Line 210: FROM FA_DEPRN_PERIODS

206: AND PERIOD_COUNTER > (SELECT MAX(fdp.period_counter)
207: FROM fa_deprn_periods fdp
208: WHERE FDP.book_type_code = P_BOOK_NAME
209: AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
210: FROM FA_DEPRN_PERIODS
211: WHERE book_type_code = P_BOOK_NAME
212: AND period_close_date IS NOT NULL));
213: END IF;
214:

Line 240: FROM FA_DEPRN_PERIODS_MRC_V fdp

236: FROM FA_DEPRN_SUMMARY_MRC_V
237: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
238: AND ASSET_ID = p_asset_id_in
239: AND PERIOD_COUNTER <= (SELECT MAX(fdp.period_counter)
240: FROM FA_DEPRN_PERIODS_MRC_V fdp
241: WHERE FDP.book_type_code = P_BOOK_NAME
242: AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
243: FROM FA_DEPRN_PERIODS_MRC_V
244: WHERE book_type_code = P_BOOK_NAME

Line 243: FROM FA_DEPRN_PERIODS_MRC_V

239: AND PERIOD_COUNTER <= (SELECT MAX(fdp.period_counter)
240: FROM FA_DEPRN_PERIODS_MRC_V fdp
241: WHERE FDP.book_type_code = P_BOOK_NAME
242: AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
243: FROM FA_DEPRN_PERIODS_MRC_V
244: WHERE book_type_code = P_BOOK_NAME
245: AND period_close_date IS NOT NULL));
246:
247: ELSE

Line 255: FROM FA_DEPRN_PERIODS fdp

251: FROM FA_DEPRN_SUMMARY
252: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
253: AND ASSET_ID = p_asset_id_in
254: AND PERIOD_COUNTER <= (SELECT MAX(fdp.period_counter)
255: FROM FA_DEPRN_PERIODS fdp
256: WHERE FDP.book_type_code = P_BOOK_NAME
257: AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
258: FROM FA_DEPRN_PERIODS
259: WHERE book_type_code = P_BOOK_NAME

Line 258: FROM FA_DEPRN_PERIODS

254: AND PERIOD_COUNTER <= (SELECT MAX(fdp.period_counter)
255: FROM FA_DEPRN_PERIODS fdp
256: WHERE FDP.book_type_code = P_BOOK_NAME
257: AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
258: FROM FA_DEPRN_PERIODS
259: WHERE book_type_code = P_BOOK_NAME
260: AND period_close_date IS NOT NULL));
261:
262: END IF;

Line 289: FROM FA_DEPRN_PERIODS_MRC_V fdp

285: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
286: AND ASSET_ID = p_asset_id_in
287: AND PERIOD_COUNTER = P_PERIOD_COUNTER
288: AND PERIOD_COUNTER <= (SELECT MAX(fdp.period_counter)
289: FROM FA_DEPRN_PERIODS_MRC_V fdp
290: WHERE FDP.book_type_code = P_BOOK_NAME
291: AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
292: FROM FA_DEPRN_PERIODS_MRC_V
293: WHERE book_type_code = P_BOOK_NAME

Line 292: FROM FA_DEPRN_PERIODS_MRC_V

288: AND PERIOD_COUNTER <= (SELECT MAX(fdp.period_counter)
289: FROM FA_DEPRN_PERIODS_MRC_V fdp
290: WHERE FDP.book_type_code = P_BOOK_NAME
291: AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
292: FROM FA_DEPRN_PERIODS_MRC_V
293: WHERE book_type_code = P_BOOK_NAME
294: AND period_close_date IS NOT NULL));
295:
296: ELSE

Line 304: FROM fa_deprn_periods fdp

300: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
301: AND ASSET_ID = p_asset_id_in
302: AND PERIOD_COUNTER = P_PERIOD_COUNTER
303: AND PERIOD_COUNTER <= (SELECT MAX(fdp.period_counter)
304: FROM fa_deprn_periods fdp
305: WHERE FDP.book_type_code = P_BOOK_NAME
306: AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
307: FROM FA_DEPRN_PERIODS
308: WHERE book_type_code = P_BOOK_NAME

Line 307: FROM FA_DEPRN_PERIODS

303: AND PERIOD_COUNTER <= (SELECT MAX(fdp.period_counter)
304: FROM fa_deprn_periods fdp
305: WHERE FDP.book_type_code = P_BOOK_NAME
306: AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
307: FROM FA_DEPRN_PERIODS
308: WHERE book_type_code = P_BOOK_NAME
309: AND period_close_date IS NOT NULL));
310:
311: END IF;

Line 411: FROM FA_DEPRN_PERIODS_MRC_V

407: IF upper(P_MRCSOBTYPE) = 'R'
408: THEN
409: SELECT PERIOD_COUNTER
410: INTO p_lex_begin_period_counter
411: FROM FA_DEPRN_PERIODS_MRC_V
412: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
413: AND PERIOD_NAME = P_BEGIN_PERIOD;
414: fnd_file.put_line(fnd_file.log,'R-p_lex_begin_period_counter::'||p_lex_begin_period_counter);
415:

Line 418: FROM FA_DEPRN_PERIODS_MRC_V

414: fnd_file.put_line(fnd_file.log,'R-p_lex_begin_period_counter::'||p_lex_begin_period_counter);
415:
416: SELECT PERIOD_COUNTER
417: INTO p_lex_end_period_counter
418: FROM FA_DEPRN_PERIODS_MRC_V
419: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
420: AND PERIOD_NAME = P_END_PERIOD;
421: fnd_file.put_line(fnd_file.log,'R-p_lex_end_period_counter::'||p_lex_end_period_counter);
422:

Line 432: FROM FA_DEPRN_PERIODS

428:
429: ELSE
430: SELECT PERIOD_COUNTER
431: INTO p_lex_begin_period_counter
432: FROM FA_DEPRN_PERIODS
433: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
434: AND PERIOD_NAME = P_BEGIN_PERIOD;
435: fnd_file.put_line(fnd_file.log,'p_lex_begin_period_counter::'||p_lex_begin_period_counter);
436:

Line 439: FROM FA_DEPRN_PERIODS

435: fnd_file.put_line(fnd_file.log,'p_lex_begin_period_counter::'||p_lex_begin_period_counter);
436:
437: SELECT PERIOD_COUNTER
438: INTO p_lex_end_period_counter
439: FROM FA_DEPRN_PERIODS
440: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
441: AND PERIOD_NAME = P_END_PERIOD;
442: fnd_file.put_line(fnd_file.log,'p_lex_end_period_counter::'||p_lex_end_period_counter);
443:

Line 460: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS_MRC_V';

456: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS_MRC_V';
457: LP_FA_BOOKS := 'FA_BOOKS_MRC_V';
458: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS_MRC_V';
459: LP_FA_RETIREMENTS := 'FA_RETIREMENTS_MRC_V';
460: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS_MRC_V';
461: LP_FA_ASSET_INVOICES := 'FA_ASSET_INVOICES_MRC_V';
462: ELSE
463: lp_fa_book_controls := 'FA_BOOK_CONTROLS';
464: lp_fa_books := 'FA_BOOKS';

Line 467: lp_fa_deprn_periods := 'FA_DEPRN_PERIODS';

463: lp_fa_book_controls := 'FA_BOOK_CONTROLS';
464: lp_fa_books := 'FA_BOOKS';
465: lp_fa_adjustments := 'FA_ADJUSTMENTS';
466: lp_fa_retirements := 'FA_RETIREMENTS';
467: lp_fa_deprn_periods := 'FA_DEPRN_PERIODS';
468: lp_fa_asset_invoices := 'FA_ASSET_INVOICES';
469:
470: END IF;
471: