DBA Data[Home] [Help]

APPS.FA_CACHE_PKG dependencies on FA_DEPRN_PERIODS

Line 2217: FROM fa_deprn_periods

2213: calendar_period_open_date,
2214: calendar_period_close_date,
2215: deprn_run
2216: INTO fazcdp_record
2217: FROM fa_deprn_periods
2218: WHERE book_type_code = X_book_type_code
2219: AND period_counter = X_period_counter;
2220: elsif X_effective_date is not null then
2221: SELECT book_type_code,

Line 2232: FROM fa_deprn_periods

2228: calendar_period_open_date,
2229: calendar_period_close_date,
2230: deprn_run
2231: INTO fazcdp_record
2232: FROM fa_deprn_periods
2233: WHERE book_type_code = X_book_type_code
2234: AND x_effective_date between
2235: period_open_date and nvl(period_close_date, sysdate);
2236: else

Line 2248: FROM fa_deprn_periods

2244: calendar_period_open_date,
2245: calendar_period_close_date,
2246: deprn_run
2247: INTO fazcdp_record
2248: FROM fa_deprn_periods
2249: WHERE book_type_code = X_book_type_code
2250: AND period_close_date is null;
2251: end if;
2252: