APPS.IGI_IAC_RETIREMENT dependencies on FA_BOOKS

Line 133: CURSOR c_check_revaluations (p_asset_id fa_books.asset_id%TYPE,

129: AND NVL(fad.assigned_to,-1) = p_assigned_to
130: AND fad.transaction_header_id_out IS NULL;
131:
132:
133: CURSOR c_check_revaluations (p_asset_id fa_books.asset_id%TYPE,
134: p_book_type_code fa_books.book_type_code%TYPE,
135: p_retire_period Number,
136: p_current_period NUmber) IS
137: SELECT *

Line 134: p_book_type_code fa_books.book_type_code%TYPE,

130: AND fad.transaction_header_id_out IS NULL;
131:
132:
133: CURSOR c_check_revaluations (p_asset_id fa_books.asset_id%TYPE,
134: p_book_type_code fa_books.book_type_code%TYPE,
135: p_retire_period Number,
136: p_current_period NUmber) IS
137: SELECT *
138: FROM igi_iac_transaction_headers

Line 147: CURSOR c_get_all_occ_reval(p_asset_id fa_books.asset_id%TYPE,

143: AND transaction_type_code='REVALUATION'
144: AND adjustment_status='RUN';
145:
146:
147: CURSOR c_get_all_occ_reval(p_asset_id fa_books.asset_id%TYPE,
148: p_book_type_code fa_books.book_type_code%TYPE,
149: p_retire_period Number,
150: p_current_period NUmber,
151: p_distribution_id Number ) IS

Line 148: p_book_type_code fa_books.book_type_code%TYPE,

144: AND adjustment_status='RUN';
145:
146:
147: CURSOR c_get_all_occ_reval(p_asset_id fa_books.asset_id%TYPE,
148: p_book_type_code fa_books.book_type_code%TYPE,
149: p_retire_period Number,
150: p_current_period NUmber,
151: p_distribution_id Number ) IS
152: SELECT asset_id,distribution_id,adjustment_type,SUM(DECODE(dr_cr_flag,'CR',1,-1)*Amount) amount,

Line 168: CURSOR c_check_depreciations (p_asset_id fa_books.asset_id%TYPE,

164: AND transaction_type_code ='REVALUATION'
165: AND adjustment_status ='RUN')
166: GROUP BY asset_id,distribution_id,adjustment_type,adjustment_offset_type,report_ccid,code_combination_id,units_assigned;
167:
168: CURSOR c_check_depreciations (p_asset_id fa_books.asset_id%TYPE,
169: p_book_type_code fa_books.book_type_code%TYPE,
170: p_retire_period Number,
171: p_current_period NUmber) IS
172: SELECT *

Line 169: p_book_type_code fa_books.book_type_code%TYPE,

165: AND adjustment_status ='RUN')
166: GROUP BY asset_id,distribution_id,adjustment_type,adjustment_offset_type,report_ccid,code_combination_id,units_assigned;
167:
168: CURSOR c_check_depreciations (p_asset_id fa_books.asset_id%TYPE,
169: p_book_type_code fa_books.book_type_code%TYPE,
170: p_retire_period Number,
171: p_current_period NUmber) IS
172: SELECT *
173: FROM igi_iac_transaction_headers

Line 182: CURSOR c_get_all_prd_reval(p_asset_id fa_books.asset_id%TYPE,

178: AND transaction_type_code='DEPRECIATION'
179: AND adjustment_status='COMPLETE';
180:
181:
182: CURSOR c_get_all_prd_reval(p_asset_id fa_books.asset_id%TYPE,
183: p_book_type_code fa_books.book_type_code%TYPE,
184: p_retire_period Number,
185: p_current_period NUmber,
186: p_distribution_id Number ) IS

Line 183: p_book_type_code fa_books.book_type_code%TYPE,

179: AND adjustment_status='COMPLETE';
180:
181:
182: CURSOR c_get_all_prd_reval(p_asset_id fa_books.asset_id%TYPE,
183: p_book_type_code fa_books.book_type_code%TYPE,
184: p_retire_period Number,
185: p_current_period NUmber,
186: p_distribution_id Number ) IS
187: SELECT asset_id,distribution_id,adjustment_type,SUM(DECODE(dr_cr_flag,'CR',1,-1)*Amount) amount,

Line 204: CURSOR C_get_prior_dist ( p_asset_id fa_books.asset_id%TYPE,

200: AND adjustment_status ='COMPLETE')
201: GROUP BY asset_id,distribution_id,adjustment_type,adjustment_offset_type,report_ccid,code_combination_id,units_assigned;
202:
203:
204: CURSOR C_get_prior_dist ( p_asset_id fa_books.asset_id%TYPE,
205: p_book_type_code fa_books.book_type_code%TYPE,
206: p_distribution_id Number,
207: P_period_counter Number) IS
208: SELECT *

Line 205: p_book_type_code fa_books.book_type_code%TYPE,

201: GROUP BY asset_id,distribution_id,adjustment_type,adjustment_offset_type,report_ccid,code_combination_id,units_assigned;
202:
203:
204: CURSOR C_get_prior_dist ( p_asset_id fa_books.asset_id%TYPE,
205: p_book_type_code fa_books.book_type_code%TYPE,
206: p_distribution_id Number,
207: P_period_counter Number) IS
208: SELECT *
209: FROM igi_iac_det_balances