APPS.IGI_IAC_COMMON_UTILS dependencies on FA_TRANSACTION_HEADERS

Line 318: l_transaction_type fa_transaction_headers.transaction_type_code%TYPE ;

314: P_Type OUT NOCOPY VARCHAR2
315: )
316: RETURN BOOLEAN AS
317: l_units NUMBER;
318: l_transaction_type fa_transaction_headers.transaction_type_code%TYPE ;
319: l_path_name VARCHAR2(150);
320: BEGIN
321: l_units := 0 ;
322: l_path_name := g_path||'get_retirement_type';

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 565: FROM fa_transaction_headers ft ,

561: l_path_name := g_path||'any_txns_in_open_period';
562:
563: SELECT count(*)
564: INTO l_tot_records
565: FROM fa_transaction_headers ft ,
566: fa_deprn_periods dp
567: WHERE ft.book_type_Code = P_book_type_code
568: AND ft.asset_id = P_asset_id
569: AND dp.book_type_Code = P_book_type_code

Line 602: FROM fa_transaction_headers ft

598: l_path_name := g_path||'any_adj_in_book';
599:
600: SELECT count(*)
601: INTO l_tot_records
602: FROM fa_transaction_headers ft
603: WHERE ft.book_type_Code = P_book_type_code
604: AND ft.asset_id = P_asset_id
605: AND ft.transaction_type_Code = 'ADJUSTMENT';
606:

Line 635: FROM fa_transaction_headers ft

631: l_path_name := g_path||'any_reval_in_corp_book';
632:
633: SELECT count(*)
634: INTO l_tot_records
635: FROM fa_transaction_headers ft
636: WHERE ft.book_type_Code = P_book_type_code
637: AND ft.asset_id = P_asset_id
638: AND ft.transaction_type_Code = 'REVALUATION';
639:

Line 709: FROM fa_transaction_headers t

705: AND r.asset_id = P_asset_id
706: AND r.status IN ('PROCESSED' , 'PENDING', 'PARTIAL' , 'REINSTATE' )
707: AND r.date_retired >= l_fy_start_date
708: AND EXISTS ( SELECT 'x'
709: FROM fa_transaction_headers t
710: WHERE t.transaction_header_id = r.transaction_header_id_in
711: AND t.transaction_type_code = 'FULL RETIREMENT' );
712:
713: -- bug 2452521, end (1)

Line 2162: CURSOR c_get_asset_adj (p_book_type_code fa_transaction_headers.book_type_code%TYPE,

2158: FUNCTION Is_Asset_Adjustment_Done(
2159: X_book_type_code IN VARCHAR2,
2160: X_asset_id IN NUMBER)
2161: RETURN BOOLEAN IS
2162: CURSOR c_get_asset_adj (p_book_type_code fa_transaction_headers.book_type_code%TYPE,
2163: p_asset_id fa_transaction_headers.asset_id%TYPE,
2164: p_period_counter number) is
2165: SELECT 1
2166: FROM dual

Line 2163: p_asset_id fa_transaction_headers.asset_id%TYPE,

2159: X_book_type_code IN VARCHAR2,
2160: X_asset_id IN NUMBER)
2161: RETURN BOOLEAN IS
2162: CURSOR c_get_asset_adj (p_book_type_code fa_transaction_headers.book_type_code%TYPE,
2163: p_asset_id fa_transaction_headers.asset_id%TYPE,
2164: p_period_counter number) is
2165: SELECT 1
2166: FROM dual
2167: WHERE EXISTS