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 156: from FA_DEPRN_TAX_REP_ITF

152:
153: begin
154: select 'YES'
155: into l_found
156: from FA_DEPRN_TAX_REP_ITF
157: where REQUEST_ID = p_request_id;
158: exception
159: when others then
160: l_found := 'NO';