APPS.FA_QUERY_BALANCES_PKG dependencies on FA_MC_DEPRN_SUMMARY

Line 799: FROM FA_MC_DEPRN_SUMMARY DS

795: NVL(PRIOR_FY_BONUS_EXPENSE, 0),
796: NVL(CAPITAL_ADJUSTMENT,0), --Bug 6666666
797: NVL(GENERAL_FUND,0), --Bug 6666666
798: NVL(REVAL_LOSS_BALANCE,0)
799: FROM FA_MC_DEPRN_SUMMARY DS
800: WHERE DS.ASSET_ID = X_dpr_row.asset_id
801: AND DS.BOOK_TYPE_CODE = X_dpr_row.book
802: AND DS.PERIOD_COUNTER <= h_period_counter
803: AND DS.SET_OF_BOOKS_ID = X_dpr_row.set_of_books_id

Line 938: FROM FA_MC_DEPRN_SUMMARY DS

934: sum(NVL(PRIOR_FY_EXPENSE, 0)),
935: sum(NVL(PRIOR_FY_BONUS_EXPENSE, 0)),
936: sum(NVL(CAPITAL_ADJUSTMENT,0)), --Bug 6666666
937: sum(NVL(GENERAL_FUND,0)) --Bug 6666666
938: FROM FA_MC_DEPRN_SUMMARY DS
939: WHERE DS.ASSET_ID in (select bk.asset_id
940: from fa_books bk
941: where bk.book_type_code = x_dpr_row.book
942: and bk.transaction_header_id_out is null

Line 947: AND DS.PERIOD_COUNTER = ( select max(period_counter) from fa_mc_deprn_summary

943: and bk.group_asset_id = x_dpr_row.asset_id)
944: AND DS.BOOK_TYPE_CODE = X_dpr_row.book
945: AND DS.SET_OF_BOOKS_ID = X_dpr_row.set_of_books_id
946: -- Bug#6350172: Modified query to fetch correct reserve values
947: AND DS.PERIOD_COUNTER = ( select max(period_counter) from fa_mc_deprn_summary
948: where asset_id = ds.asset_id
949: and book_type_code = X_dpr_row.book
950: and set_of_books_id = X_dpr_row.set_of_books_id);
951: