APPS.FA_QUERY_BALANCES_PKG dependencies on FA_DEPRN_SUMMARY_MRC_V

Line 802: FROM FA_DEPRN_SUMMARY_MRC_V DS

798: DEPRN_SOURCE_CODE,
799: 0,
800: NVL(PRIOR_FY_EXPENSE, 0),
801: NVL(PRIOR_FY_BONUS_EXPENSE, 0)
802: FROM FA_DEPRN_SUMMARY_MRC_V DS
803: WHERE DS.ASSET_ID = X_dpr_row.asset_id
804: AND DS.BOOK_TYPE_CODE = X_dpr_row.book
805: AND DS.PERIOD_COUNTER <= h_period_counter
806: ORDER BY PERIOD_COUNTER DESC;

Line 911: FROM FA_DEPRN_SUMMARY_MRC_V DS

907: 'DEPRN' DEPRN_SOURCE_CODE,
908: 0,
909: sum(NVL(PRIOR_FY_EXPENSE, 0)),
910: sum(NVL(PRIOR_FY_BONUS_EXPENSE, 0))
911: FROM FA_DEPRN_SUMMARY_MRC_V DS
912: WHERE DS.ASSET_ID in (select bk.asset_id
913: from fa_books bk
914: where bk.book_type_code = x_dpr_row.book
915: and bk.transaction_header_id_out is null