APPS.FA_JAPAN_DEP_TAX_SUMMARY_PKG dependencies on FA_DEPRN_TAX_REP_ITF
Line 132: from FA_DEPRN_TAX_REP_ITF DTI
128: begin
129:
130: select sum(theoretical_nbv), sum(evaluated_nbv)
131: into c_sum_theoretical_nbv, c_sum_evaluated_nbv 132: from FA_DEPRN_TAX_REP_ITF DTI 133: where DTI.END_COST >0
134: and DTI.STATE = l_state
135: and DTI.REQUEST_ID = p_request_id;
136:
Line 159: from FA_DEPRN_TAX_REP_ITF
155:
156: begin
157: select count(1)
158: into l_count 159: from FA_DEPRN_TAX_REP_ITF 160: where REQUEST_ID = p_request_id
161: and ASSET_ID IS NOT NULL;
162:
163: if l_count > 0 then