APPS.IGI_IAC_COMMON_UTILS dependencies on FA_RETIREMENTS

Line 215: P_Retire_Info OUT NOCOPY fa_retirements%ROWTYPE

211:
212:
213:
214: Function Get_Retirement_Info ( P_Retirement_Id IN NUMBER ,
215: P_Retire_Info OUT NOCOPY fa_retirements%ROWTYPE
216: )
217: RETURN BOOLEAN AS
218:
219: l_index NUMBER;

Line 224: FROM fa_retirements

220: l_path_name VARCHAR2(150);
221:
222: CURSOR c_ret IS
223: SELECT *
224: FROM fa_retirements
225: WHERE retirement_id = P_Retirement_Id ;
226:
227: BEGIN
228: l_index := 0 ;

Line 261: l_Retire_Info fa_retirements%ROWTYPE ;

257: P_Units_Before OUT NOCOPY NUMBER ,
258: P_Units_After OUT NOCOPY NUMBER
259: )
260: RETURN BOOLEAN AS
261: l_Retire_Info fa_retirements%ROWTYPE ;
262: l_txn_id_before NUMBER ;
263: l_path_name VARCHAR2(150);
264: BEGIN
265: l_path_name := g_path||'get_units_info_for_gain_loss';

Line 316: FROM fa_books b, fa_retirements r

312: l_path_name := g_path||'get_cost_retirement_factor';
313:
314: SELECT b.cost, r.cost_retired
315: INTO l_cost, l_cost_retired
316: FROM fa_books b, fa_retirements r
317: WHERE b.book_type_code = P_book_type_Code
318: AND b.asset_id = P_asset_id
319: AND r.retirement_id = P_retirement_id
320: AND r.retirement_id = b.retirement_id ;

Line 349: FROM fa_transaction_headers t, fa_retirements r

345: l_path_name := g_path||'get_retirement_type';
346:
347: SELECT t.transaction_type_code
348: INTO l_transaction_type
349: FROM fa_transaction_headers t, fa_retirements r
350: WHERE t.transaction_header_id = r.transaction_header_id_in
351: AND r.retirement_id = P_retirement_id ;
352:
353: SELECT r.units

Line 355: FROM fa_retirements r

351: AND r.retirement_id = P_retirement_id ;
352:
353: SELECT r.units
354: INTO l_units
355: FROM fa_retirements r
356: --ssmales WHERE r.transaction_header_id_in = P_transaction_header_id
357: WHERE r.retirement_id = P_retirement_id
358: AND r.book_type_code = P_book_type_code
359: AND r.asset_id = P_asset_id ;

Line 723: FROM fa_retirements r

719: -- bug 2452521, start (1)
720:
721: /* SELECT count(*)
722: INTO l_tot_retirements
723: FROM fa_retirements r
724: WHERE r.book_type_code = P_book_type_Code
725: AND r.asset_id = P_asset_id
726: AND r.status IN ('PROCESSED' , 'PENDING', 'PARTIAL' , 'REINSTATE' )
727: AND r.date_retired >= l_fy_start_date ;

Line 732: FROM fa_retirements r

728: */
729:
730: SELECT count(*)
731: INTO l_tot_retirements
732: FROM fa_retirements r
733: WHERE r.book_type_code = P_book_type_Code
734: AND r.transaction_header_id_out IS NULL
735: AND r.asset_id = P_asset_id
736: AND r.status IN ('PROCESSED' , 'PENDING', 'PARTIAL' , 'REINSTATE' )