DBA Data[Home] [Help]

APPS.IGI_IAC_REVAL_HIST_PKG dependencies on FA_ASSET_HISTORY

Line 138: FROM fa_asset_history fah

134: AND fb.asset_id = igth.asset_id
135: AND fb.book_type_code = igth.book_type_code
136: AND igth.adjustment_id_out = cp_adj_id
137: AND fb.date_effective < (SELECT fah.date_effective
138: FROM fa_asset_history fah
139: WHERE fah.transaction_header_id_in = igth.transaction_header_id
140: AND fah.asset_id = p_asset_id)
141: AND nvl(fb.date_ineffective,igth.transaction_date_entered) >= igth.transaction_date_entered;
142:

Line 155: FROM fa_asset_history fah

151: AND fb.asset_id = igth.asset_id
152: AND fb.book_type_code = igth.book_type_code
153: AND igth.adjustment_id = cp_adj_id
154: AND fb.date_effective < (SELECT fah.date_effective
155: FROM fa_asset_history fah
156: WHERE fah.transaction_header_id_in = igth.transaction_header_id
157: AND fah.asset_id = p_asset_id)
158: AND nvl(fb.date_ineffective,igth.transaction_date_entered) >= igth.transaction_date_entered;
159: -- bug 3587648, end 1