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 104: FROM FA_DEPRN_SUMMARY_MRC_V

100: THEN
101: /* Bug#8915053,9103594-Changes done as per new formula for Depr.Claim Rate */
102: SELECT count(PERIOD_COUNTER)
103: INTO ln_number
104: FROM FA_DEPRN_SUMMARY_MRC_V
105: WHERE book_type_code = p_book_name
106: AND asset_id = p_asset_id_in
107: AND period_counter BETWEEN p_lex_begin_period_counter AND p_lex_end_period_counter
108: AND deprn_source_code = 'DEPRN'

Line 114: FROM fa_Deprn_summary

110: ELSE
111: /* Bug#8915053,9103594-Changes done as per new formula for Depr.Claim Rate */
112: SELECT count(PERIOD_COUNTER)
113: INTO ln_number
114: FROM fa_Deprn_summary
115: WHERE book_type_code = p_book_name
116: AND asset_id = p_asset_id_in
117: AND period_counter BETWEEN p_lex_begin_period_counter AND p_lex_end_period_counter
118: AND deprn_source_code = 'DEPRN'

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: --Bug#9337624:Changes done to calculate ytd correctly.

Line 146: FROM FA_DEPRN_SUMMARY_MRC_V

142: --Bug#9337624:Changes done to calculate ytd correctly.
143: IF upper(P_MRCSOBTYPE) = 'R' THEN
144: SELECT sum(deprn_amount)
145: INTO ln_amount
146: FROM FA_DEPRN_SUMMARY_MRC_V
147: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
148: AND ASSET_ID = p_asset_id_in
149: AND DEPRN_SOURCE_CODE = 'DEPRN'
150: AND PERIOD_COUNTER BETWEEN p_lex_begin_period_counter AND p_lex_end_period_counter;

Line 154: FROM FA_DEPRN_SUMMARY

150: AND PERIOD_COUNTER BETWEEN p_lex_begin_period_counter AND p_lex_end_period_counter;
151: ELSE
152: SELECT sum(deprn_amount)
153: INTO ln_amount
154: FROM FA_DEPRN_SUMMARY
155: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
156: AND ASSET_ID = p_asset_id_in
157: AND DEPRN_SOURCE_CODE = 'DEPRN'
158: AND PERIOD_COUNTER BETWEEN p_lex_begin_period_counter AND p_lex_end_period_counter;

Line 179: FROM FA_DEPRN_SUMMARY

175: ln_amount NUMBER;
176: BEGIN
177: /*SELECT SUM(DEPRN_AMOUNT)
178: INTO ln_amount
179: FROM FA_DEPRN_SUMMARY
180: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
181: AND ASSET_ID = p_asset_id_in
182: AND PERIOD_COUNTER BETWEEN p_lex_begin_period_counter AND p_lex_end_period_counter;*/
183: IF upper(P_MRCSOBTYPE) = 'R'

Line 187: FROM FA_DEPRN_SUMMARY_MRC_V

183: IF upper(P_MRCSOBTYPE) = 'R'
184: THEN
185: SELECT DEPRN_ADJUSTMENT_AMOUNT
186: INTO ln_amount
187: FROM FA_DEPRN_SUMMARY_MRC_V
188: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
189: AND ASSET_ID = p_asset_id_in
190: AND period_counter = p_period_counter
191: AND PERIOD_COUNTER > (SELECT MAX(fdp.period_counter)

Line 202: FROM FA_DEPRN_SUMMARY

198: ELSE
199:
200: SELECT DEPRN_ADJUSTMENT_AMOUNT
201: INTO ln_amount
202: FROM FA_DEPRN_SUMMARY
203: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
204: AND ASSET_ID = p_asset_id_in
205: AND period_counter = p_period_counter
206: AND PERIOD_COUNTER > (SELECT MAX(fdp.period_counter)

Line 236: FROM FA_DEPRN_SUMMARY_MRC_V

232: IF upper(P_MRCSOBTYPE) = 'R'
233: THEN
234: SELECT SUM(DEPRN_AMOUNT)
235: INTO ln_amount
236: FROM FA_DEPRN_SUMMARY_MRC_V
237: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
238: AND ASSET_ID = p_asset_id_in
239: AND PERIOD_COUNTER <= (SELECT MAX(fdp.period_counter)
240: FROM FA_DEPRN_PERIODS_MRC_V fdp

Line 251: FROM FA_DEPRN_SUMMARY

247: ELSE
248:
249: SELECT SUM(DEPRN_AMOUNT)
250: INTO ln_amount
251: FROM FA_DEPRN_SUMMARY
252: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
253: AND ASSET_ID = p_asset_id_in
254: AND PERIOD_COUNTER <= (SELECT MAX(fdp.period_counter)
255: FROM FA_DEPRN_PERIODS fdp

Line 284: FROM FA_DEPRN_SUMMARY_MRC_V

280: IF upper(P_MRCSOBTYPE) = 'R'
281: THEN
282: SELECT SUM(DEPRN_ADJUSTMENT_AMOUNT)
283: INTO ln_amount
284: FROM FA_DEPRN_SUMMARY_MRC_V
285: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
286: AND ASSET_ID = p_asset_id_in
287: AND PERIOD_COUNTER = P_PERIOD_COUNTER
288: AND PERIOD_COUNTER <= (SELECT MAX(fdp.period_counter)

Line 299: FROM FA_DEPRN_SUMMARY

295:
296: ELSE
297: SELECT SUM(DEPRN_ADJUSTMENT_AMOUNT)
298: INTO ln_amount
299: FROM FA_DEPRN_SUMMARY
300: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
301: AND ASSET_ID = p_asset_id_in
302: AND PERIOD_COUNTER = P_PERIOD_COUNTER
303: AND PERIOD_COUNTER <= (SELECT MAX(fdp.period_counter)