APPS.FA_TOFES_YUD_ALEF_PKG dependencies on FA_DEPRN_SUMMARY_MRC_V

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 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 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 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 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)