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.

[Home] [Help]

APPS.FA_CACHE_PKG dependencies on FA_DEPRN_PERIODS

Line 2501: FROM fa_deprn_periods

2497: calendar_period_open_date,
2498: calendar_period_close_date,
2499: deprn_run
2500: INTO fazcdp_record
2501: FROM fa_deprn_periods
2502: WHERE book_type_code = X_book_type_code
2503: AND period_counter = X_period_counter;
2504: elsif X_effective_date is not null then
2505: SELECT book_type_code,

Line 2516: FROM fa_deprn_periods

2512: calendar_period_open_date,
2513: calendar_period_close_date,
2514: deprn_run
2515: INTO fazcdp_record
2516: FROM fa_deprn_periods
2517: WHERE book_type_code = X_book_type_code
2518: AND x_effective_date between
2519: period_open_date and nvl(period_close_date, sysdate);
2520: else

Line 2532: FROM fa_deprn_periods

2528: calendar_period_open_date,
2529: calendar_period_close_date,
2530: deprn_run
2531: INTO fazcdp_record
2532: FROM fa_deprn_periods
2533: WHERE book_type_code = X_book_type_code
2534: AND period_close_date is null;
2535: end if;
2536: