DBA Data[Home] [Help]

APPS.IGI_IAC_DEPRN_PKG dependencies on FA_TRANSACTION_HEADERS

Line 233: FROM fa_transaction_headers

229:
230: /* Cursor to get the date of the transaction */
231: CURSOR c_get_transaction_info(p_transaction_id fa_books.transaction_header_id_in%TYPE) IS
232: SELECT transaction_date_entered
233: FROM fa_transaction_headers
234: WHERE transaction_header_id = p_transaction_id;
235:
236: /* Cursor to get Current active transaction for asset from IAC */
237: CURSOR c_get_prev_adjustment(p_asset_id igi_iac_transaction_headers.asset_id%TYPE) IS

Line 365: l_transaction_date fa_transaction_headers.transaction_date_entered%TYPE;

361: l_total_periods NUMBER;
362: l_last_period_counter NUMBER;
363: l_max_period_counter NUMBER;
364: l_fa_transaction_id fa_books.transaction_header_id_in%TYPE;
365: l_transaction_date fa_transaction_headers.transaction_date_entered%TYPE;
366: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
367: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;
368: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;
369: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;