DBA Data[Home] [Help]

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