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 85: ,FA_DEPRN_PERIODS FDP

81: ELSE (MONTHS_BETWEEN(ADD_MONTHS(FB.DATE_PLACED_IN_SERVICE,FB.LIFE_IN_MONTHS), FDP.PERIOD_OPEN_DATE))
82: END
83: INTO ln_number
84: FROM FA_BOOKS FB
85: ,FA_DEPRN_PERIODS FDP
86: WHERE FB.BOOK_type_code = FDP.book_type_code
87: AND FB.BOOK_type_code = P_BOOK_NAME
88: AND FDP.period_counter = p_lex_begin_period_counter
89: AND FB.DEPRECIATE_FLAG = 'YES'

Line 149: FROM fa_deprn_periods fdp

145: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
146: AND ASSET_ID = p_asset_id_in
147: AND period_counter = p_period_counter
148: AND PERIOD_COUNTER > (SELECT MAX(fdp.period_counter)
149: FROM fa_deprn_periods fdp
150: WHERE FDP.book_type_code = P_BOOK_NAME
151: AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
152: FROM FA_DEPRN_PERIODS
153: WHERE book_type_code = P_BOOK_NAME

Line 152: FROM FA_DEPRN_PERIODS

148: AND PERIOD_COUNTER > (SELECT MAX(fdp.period_counter)
149: FROM fa_deprn_periods fdp
150: WHERE FDP.book_type_code = P_BOOK_NAME
151: AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
152: FROM FA_DEPRN_PERIODS
153: WHERE book_type_code = P_BOOK_NAME
154: AND period_close_date IS NOT NULL));
155: RETURN ln_amount;
156: EXCEPTION

Line 176: FROM fa_deprn_periods fdp

172: FROM FA_DEPRN_SUMMARY
173: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
174: AND ASSET_ID = p_asset_id_in
175: AND PERIOD_COUNTER <= (SELECT MAX(fdp.period_counter)
176: FROM fa_deprn_periods fdp
177: WHERE FDP.book_type_code = P_BOOK_NAME
178: AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
179: FROM FA_DEPRN_PERIODS
180: WHERE book_type_code = P_BOOK_NAME

Line 179: FROM FA_DEPRN_PERIODS

175: AND PERIOD_COUNTER <= (SELECT MAX(fdp.period_counter)
176: FROM fa_deprn_periods fdp
177: WHERE FDP.book_type_code = P_BOOK_NAME
178: AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
179: FROM FA_DEPRN_PERIODS
180: WHERE book_type_code = P_BOOK_NAME
181: AND period_close_date IS NOT NULL));
182: RETURN ln_amount;
183: EXCEPTION

Line 204: FROM fa_deprn_periods fdp

200: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
201: AND ASSET_ID = p_asset_id_in
202: AND PERIOD_COUNTER = P_PERIOD_COUNTER
203: AND PERIOD_COUNTER <= (SELECT MAX(fdp.period_counter)
204: FROM fa_deprn_periods fdp
205: WHERE FDP.book_type_code = P_BOOK_NAME
206: AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
207: FROM FA_DEPRN_PERIODS
208: WHERE book_type_code = P_BOOK_NAME

Line 207: FROM FA_DEPRN_PERIODS

203: AND PERIOD_COUNTER <= (SELECT MAX(fdp.period_counter)
204: FROM fa_deprn_periods fdp
205: WHERE FDP.book_type_code = P_BOOK_NAME
206: AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
207: FROM FA_DEPRN_PERIODS
208: WHERE book_type_code = P_BOOK_NAME
209: AND period_close_date IS NOT NULL));
210: RETURN ln_amount;
211: EXCEPTION

Line 270: FROM FA_DEPRN_PERIODS

266: BEGIN
267: fnd_file.put_line(fnd_file.log,'In the Before Report Proc');
268: SELECT PERIOD_COUNTER
269: INTO p_lex_begin_period_counter
270: FROM FA_DEPRN_PERIODS
271: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
272: AND PERIOD_NAME = P_BEGIN_PERIOD;
273: fnd_file.put_line(fnd_file.log,'p_lex_begin_period_counter::'||p_lex_begin_period_counter);
274:

Line 277: FROM FA_DEPRN_PERIODS

273: fnd_file.put_line(fnd_file.log,'p_lex_begin_period_counter::'||p_lex_begin_period_counter);
274:
275: SELECT PERIOD_COUNTER
276: INTO p_lex_end_period_counter
277: FROM FA_DEPRN_PERIODS
278: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
279: AND PERIOD_NAME = P_END_PERIOD;
280: fnd_file.put_line(fnd_file.log,'p_lex_end_period_counter::'||p_lex_end_period_counter);
281: