APPS.IGI_IAC_PROJ_PKG dependencies on IGI_IAC_TRANSACTION_HEADERS

Line 346: FROM igi_iac_transaction_headers

342: FROM igi_iac_revaluation_rates irr
343: WHERE irr.book_type_code = n_book_code
344: AND asset_id = n_asset_id
345: AND irr.adjustment_id = (SELECT MAX(adjustment_id)
346: FROM igi_iac_transaction_headers
347: WHERE book_type_code = n_book_code
348: AND asset_id = n_asset_id
349: AND transaction_type_code = 'REVALUATION'
350: AND adjustment_status<>'PREVIEW');

Line 669: FROM igi_iac_transaction_headers it

665: AND id.adjustment_id = ifd.adjustment_id
666: AND id.distribution_id = ifd.distribution_id
667: AND id.period_counter = ifd.period_counter
668: AND id.adjustment_id = ( SELECT max(adjustment_id)
669: FROM igi_iac_transaction_headers it
670: WHERE it.asset_id = bk.asset_id
671: AND it.book_type_code = bk.book_type_code
672: AND it.period_counter = dd.period_counter
673: AND it.adjustment_status not in( 'PREVIEW', 'OBSOLETE'))

Line 816: FROM igi_iac_transaction_headers ith

812: AND dd.asset_id = n_asset_id
813: AND fb.transaction_header_id_out IS NULL
814: AND fb.depreciate_flag = 'NO'
815: AND dd.adjustment_id = (SELECT max(ith.adjustment_id)
816: FROM igi_iac_transaction_headers ith
817: WHERE ith.book_type_code = n_book_code
818: AND ith.asset_id = n_Asset_id
819: AND ith.adjustment_status NOT IN( 'PREVIEW', 'OBSOLETE'));
820:

Line 841: FROM igi_iac_transaction_headers ith

837: AND dd.asset_id = n_asset_id
838: AND fb.transaction_header_id_out IS NULL
839: AND fb.period_counter_fully_reserved IS NOT NULL
840: AND dd.adjustment_id = (SELECT max(ith.adjustment_id)
841: FROM igi_iac_transaction_headers ith
842: WHERE ith.book_type_code = n_book_code
843: AND ith.asset_id = n_Asset_id
844: AND ith.adjustment_status NOT IN( 'PREVIEW', 'OBSOLETE'));
845: */