APPS.FA_CDE_PKG dependencies on FA_DEPRN_PERIODS

Line 240: ' rate FROM fa_books fabk, fa_deprn_periods fadp ' ||

236: h_formula_parsed := REPLACE(h_formula_parsed, 'LIFE_IN_MONTHS', TO_CHAR(X_Life_In_Months));
237:
238: -- Fix for Bug #2939771. Use bind variables.
239: h_formula := 'SELECT ' || h_formula_parsed ||
240: ' rate FROM fa_books fabk, fa_deprn_periods fadp ' ||
241: ' WHERE (fabk.asset_id = :v1) ' ||
242: ' AND (fabk.book_type_code = :v2' ||
243: ' ) AND (fabk.book_type_code = fadp.book_type_code) ' ||
244: ' AND (fabk.date_ineffective is null) ' ||

Line 2355: FROM fa_deprn_periods pd

2351:
2352: /*Below query will fetch the current fiscal year of book*/
2353: SELECT fiscal_year
2354: INTO book_fy
2355: FROM fa_deprn_periods pd
2356: WHERE pd.book_type_code = dpr.book
2357: AND period_close_date is null;
2358:
2359: IF (dpis_fy <> book_fy) then