FA_QUERY_BALANCES_PKG and Group Asset
We are trying to use the fa_query_balances_pkg to get the nbv of assets. I am seeing expected values for all assets except when it is a group asset. Can anyone assist? We are using UOP method for our group assets. Always I am getting zero for the cost value. The below is the call details :
set serveroutput on
declare
L_PERIOD_CTR NUMBER;
l_dist_id NUMBER;
l_period_name VARCHAR2(20);
l_deprn_method VARCHAR2(10);
l_salvage_value NUMBER;
L_COST NUMBER;
L_DEPRN_RSV NUMBER;
L_REVAL_RSV NUMBER;
L_YTD_DEPRN NUMBER;
L_YTD_REVAL_EXP NUMBER;