APPS.IGI_IAC_COMMON_UTILS dependencies on FA_RETIREMENTS

Line 192: P_Retire_Info OUT NOCOPY fa_retirements%ROWTYPE

188:
189:
190:
191: Function Get_Retirement_Info ( P_Retirement_Id IN NUMBER ,
192: P_Retire_Info OUT NOCOPY fa_retirements%ROWTYPE
193: )
194: RETURN BOOLEAN AS
195:
196: l_index NUMBER;

Line 201: FROM fa_retirements

197: l_path_name VARCHAR2(150);
198:
199: CURSOR c_ret IS
200: SELECT *
201: FROM fa_retirements
202: WHERE retirement_id = P_Retirement_Id ;
203:
204: BEGIN
205: l_index := 0 ;

Line 238: l_Retire_Info fa_retirements%ROWTYPE ;

234: P_Units_Before OUT NOCOPY NUMBER ,
235: P_Units_After OUT NOCOPY NUMBER
236: )
237: RETURN BOOLEAN AS
238: l_Retire_Info fa_retirements%ROWTYPE ;
239: l_txn_id_before NUMBER ;
240: l_path_name VARCHAR2(150);
241: BEGIN
242: l_path_name := g_path||'get_units_info_for_gain_loss';

Line 293: FROM fa_books b, fa_retirements r

289: l_path_name := g_path||'get_cost_retirement_factor';
290:
291: SELECT b.cost, r.cost_retired
292: INTO l_cost, l_cost_retired
293: FROM fa_books b, fa_retirements r
294: WHERE b.book_type_code = P_book_type_Code
295: AND b.asset_id = P_asset_id
296: AND r.retirement_id = P_retirement_id
297: AND r.retirement_id = b.retirement_id ;

Line 326: FROM fa_transaction_headers t, fa_retirements r

322: l_path_name := g_path||'get_retirement_type';
323:
324: SELECT t.transaction_type_code
325: INTO l_transaction_type
326: FROM fa_transaction_headers t, fa_retirements r
327: WHERE t.transaction_header_id = r.transaction_header_id_in
328: AND r.retirement_id = P_retirement_id ;
329:
330: SELECT r.units

Line 332: FROM fa_retirements r

328: AND r.retirement_id = P_retirement_id ;
329:
330: SELECT r.units
331: INTO l_units
332: FROM fa_retirements r
333: --ssmales WHERE r.transaction_header_id_in = P_transaction_header_id
334: WHERE r.retirement_id = P_retirement_id
335: AND r.book_type_code = P_book_type_code
336: AND r.asset_id = P_asset_id ;

Line 693: FROM fa_retirements r

689: -- bug 2452521, start (1)
690:
691: /* SELECT count(*)
692: INTO l_tot_retirements
693: FROM fa_retirements r
694: WHERE r.book_type_code = P_book_type_Code
695: AND r.asset_id = P_asset_id
696: AND r.status IN ('PROCESSED' , 'PENDING', 'PARTIAL' , 'REINSTATE' )
697: AND r.date_retired >= l_fy_start_date ;

Line 702: FROM fa_retirements r

698: */
699:
700: SELECT count(*)
701: INTO l_tot_retirements
702: FROM fa_retirements r
703: WHERE r.book_type_code = P_book_type_Code
704: AND r.transaction_header_id_out IS NULL
705: AND r.asset_id = P_asset_id
706: AND r.status IN ('PROCESSED' , 'PENDING', 'PARTIAL' , 'REINSTATE' )