APPS.IGI_IAC_REVAL_HIST_PKG dependencies on FA_BOOKS

Line 82: FROM fa_books fb,igi_iac_transactioN_headers igth

78: --- fecthing the Fa_cost if transaction is Addition or Revaluation;
79: CURSOR C_get_fa_cost ( P_adj_id igi_iac_transaction_headers.adjustment_id%type)
80: IS
81: SELECT cost,date_placed_in_service
82: FROM fa_books fb,igi_iac_transactioN_headers igth
83: WHERE fb.asset_id = p_asset_id
84: AND fb.book_type_code =p_book_type_code
85: AND fb.asset_id = igth.asset_id
86: AND fb.book_type_code = igth.book_type_code

Line 97: FROM fa_books fb,

93: cp_adj_id igi_iac_transaction_headers.adjustment_id%TYPE)
94: IS
95: SELECT cost,
96: date_placed_in_service
97: FROM fa_books fb,
98: igi_iac_transaction_headers igth
99: WHERE fb.asset_id = p_asset_id
100: AND fb.book_type_code =p_book_type_code
101: AND fb.asset_id = igth.asset_id

Line 113: FROM fa_books fb,

109: cp_adj_id igi_iac_transaction_headers.adjustment_id%TYPE)
110: IS
111: SELECT cost,
112: date_placed_in_service
113: FROM fa_books fb,
114: igi_iac_transaction_headers igth
115: WHERE fb.asset_id = p_asset_id
116: AND fb.book_type_code =p_book_type_code
117: AND fb.asset_id = igth.asset_id

Line 130: FROM fa_books fb,

126: CURSOR c_get_fa_recl_cost_curr(cp_adj_id igi_iac_transaction_headers.adjustment_id%TYPE)
127: IS
128: SELECT cost,
129: date_placed_in_service
130: FROM fa_books fb,
131: igi_iac_transaction_headers igth
132: WHERE fb.asset_id = p_asset_id
133: AND fb.book_type_code = p_book_type_code
134: AND fb.asset_id = igth.asset_id

Line 147: FROM fa_books fb,

143: CURSOR c_get_fa_recl_cost_prev(cp_adj_id igi_iac_transaction_headers.adjustment_id%TYPE)
144: IS
145: SELECT cost,
146: date_placed_in_service
147: FROM fa_books fb,
148: igi_iac_transactioN_headers igth
149: WHERE fb.asset_id = p_asset_id
150: AND fb.book_type_code = p_book_type_code
151: AND fb.asset_id = igth.asset_id