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_SUMMARY

Line 111: FROM FA_DEPRN_SUMMARY

107: ln_amount NUMBER;
108: BEGIN
109: /*SELECT SUM(DEPRN_AMOUNT)
110: INTO ln_amount
111: FROM FA_DEPRN_SUMMARY
112: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
113: AND ASSET_ID = p_asset_id_in
114: AND PERIOD_COUNTER BETWEEN p_lex_begin_period_counter AND p_lex_end_period_counter;*/
115: SELECT YTD_DEPRN

Line 117: FROM FA_DEPRN_SUMMARY

113: AND ASSET_ID = p_asset_id_in
114: AND PERIOD_COUNTER BETWEEN p_lex_begin_period_counter AND p_lex_end_period_counter;*/
115: SELECT YTD_DEPRN
116: INTO ln_amount
117: FROM FA_DEPRN_SUMMARY
118: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
119: AND ASSET_ID = p_asset_id_in
120: AND PERIOD_COUNTER = p_lex_end_period_counter;
121: RETURN ln_amount;

Line 138: FROM FA_DEPRN_SUMMARY

134: ln_amount NUMBER;
135: BEGIN
136: /*SELECT SUM(DEPRN_AMOUNT)
137: INTO ln_amount
138: FROM FA_DEPRN_SUMMARY
139: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
140: AND ASSET_ID = p_asset_id_in
141: AND PERIOD_COUNTER BETWEEN p_lex_begin_period_counter AND p_lex_end_period_counter;*/
142: SELECT DEPRN_ADJUSTMENT_AMOUNT

Line 144: FROM FA_DEPRN_SUMMARY

140: AND ASSET_ID = p_asset_id_in
141: AND PERIOD_COUNTER BETWEEN p_lex_begin_period_counter AND p_lex_end_period_counter;*/
142: SELECT DEPRN_ADJUSTMENT_AMOUNT
143: INTO ln_amount
144: FROM FA_DEPRN_SUMMARY
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)

Line 172: FROM FA_DEPRN_SUMMARY

168: ln_amount NUMBER;
169: BEGIN
170: SELECT SUM(DEPRN_AMOUNT)
171: INTO ln_amount
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

Line 199: FROM FA_DEPRN_SUMMARY

195: ln_amount NUMBER;
196: BEGIN
197: SELECT SUM(DEPRN_ADJUSTMENT_AMOUNT)
198: INTO ln_amount
199: FROM FA_DEPRN_SUMMARY
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)