APPS.IGI_IAC_YTD_PRE_PROCESS_PKG dependencies on IGI_IAC_TRANSACTION_HEADERS

Line 39: FROM igi_iac_transaction_headers

35: group by fdd.asset_id,fdd.distribution_id;
36:
37: CURSOR c_get_all_iac_assets IS
38: SELECT DISTINCT asset_id
39: FROM igi_iac_transaction_headers
40: WHERE book_type_code = p_book_type_code;
41:
42: cursor c_get_dist_deprn(cp_asset_id number,cp_distribution_id number) is
43: select (nvl(deprn_amount,0) - nvl(deprn_adjustment_amount,0)) deprn_amount,

Line 102: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;

98:
99: l_fully_reserved_pc fa_books.period_counter_fully_reserved%TYPE;
100: -- bug 3421734 end 1
101:
102: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
103: l_Transaction_Id NUMBER;
104: l_Mass_Reference_ID NUMBER;
105: l_Adjustment_Id NUMBER;
106: l_Prev_Adjustment_Id NUMBER;

Line 107: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;

103: l_Transaction_Id NUMBER;
104: l_Mass_Reference_ID NUMBER;
105: l_Adjustment_Id NUMBER;
106: l_Prev_Adjustment_Id NUMBER;
107: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;
108: l_rowid VARCHAR2(300);
109: lv_mesg VARCHAR2(2000);
110: l_debug_mode VARCHAR2(1) := 'N';
111: l_deprn_amount NUMBER;