APPS.FA_JAPAN_DEP_TAX_ADDITION_PKG dependencies on FA_DEPRN_TAX_REP_ITF

Line 96: from FA_DEPRN_TAX_REP_ITF DTI

92: else
93:
94: select sum(theoretical_nbv), sum(evaluated_nbv)
95: into c_sum_theoretical_nbv, c_sum_evaluated_nbv
96: from FA_DEPRN_TAX_REP_ITF DTI
97: where DTI.END_COST >0
98: and DTI.STATE = sum_state
99: and DTI.REQUEST_ID = p_request_id;
100:

Line 122: from FA_DEPRN_TAX_REP_ITF

118:
119: if p_classification ='ADDITION' then
120: select count(asset_id)
121: into c_count
122: from FA_DEPRN_TAX_REP_ITF
123: where request_id = p_request_id
124: and year =p_year
125: and state = sum_state
126: and add_dec_flag='A';

Line 129: from FA_DEPRN_TAX_REP_ITF

125: and state = sum_state
126: and add_dec_flag='A';
127: else select count(asset_id)
128: into c_count
129: from FA_DEPRN_TAX_REP_ITF
130: where request_id = p_request_id
131: and year =p_year
132: and state = sum_state
133: and end_cost >0;