APPS.FA_PROCESS_IMPAIRMENT_PKG dependencies on FA_BOOKS

Line 167: from fa_books fbs

163: from fa_impairments imp2
164: where status = 'POSTED'
165: and ((imp2.asset_id = imp.asset_id) or
166: imp2.cash_generating_unit_id = (select cash_generating_unit_id
167: from fa_books fbs
168: where fbs.asset_id = imp.asset_id
169: and fbs.book_type_code = imp.book_type_code
170: and fbs.transaction_header_id_out is null))
171: and imp2.book_type_code = p_book_type_code

Line 176: fa_books bk

172: AND PERIOD_COUNTER_IMPAIRED = c_period_counter )
173: UNION
174: select bk.asset_id
175: from fa_impairments imp,
176: fa_books bk
177: where bk.cash_generating_unit_id = imp.cash_generating_unit_id
178: and bk.book_type_code = imp.book_type_code
179: and imp.book_type_code = p_book_type_code
180: and imp.request_id = c_request_id

Line 188: from fa_books fbs

184: from fa_impairments imp2
185: where status = 'POSTED'
186: and ((imp2.cash_generating_unit_id = imp.cash_generating_unit_id) or
187: imp2.asset_id in (select asset_id
188: from fa_books fbs
189: where fbs.cash_generating_unit_id = imp.cash_generating_unit_id
190: and fbs.book_type_code = imp.book_type_code
191: and fbs.transaction_header_id_out is null))
192: and imp2.book_type_code = p_book_type_code

Line 1546: from fa_books bk , fa_impairments imp

1542: --Bug# 7292608 When updating uploaded impairment,existing row needs to be deleted first
1543: delete from fa_itf_impairments itmp
1544: where exists
1545: (select 'Uploaded impairment'
1546: from fa_books bk , fa_impairments imp
1547: where imp.book_type_code = p_book_type_code
1548: and imp.status = l_mode
1549: and imp.request_id = p_request_id
1550: and bk.book_type_code = p_book_type_code

Line 1630: from fa_books bk

1626: , imp.SPLIT3_IMPAIR_CLASS
1627: , imp.SPLIT3_REASON
1628: , imp.SPLIT3_PERCENT
1629: , imp.SPLIT3_LOSS_ACCT -- End of Bug 6666666
1630: from fa_books bk
1631: , fa_impairments imp
1632: where imp.book_type_code = p_book_type_code
1633: and imp.status = l_mode
1634: and imp.request_id = p_request_id

Line 1661: from fa_books bk , fa_impairments imp

1657: --Bug# 7292608 When updating uploaded impairment,existing row needs to be deleted first
1658: delete from fa_itf_impairments itmp
1659: where exists
1660: (select 'Uploaded impairment'
1661: from fa_books bk , fa_impairments imp
1662: where imp.book_type_code = p_book_type_code
1663: and imp.status = l_mode
1664: and imp.request_id = p_request_id
1665: and bk.book_type_code = p_book_type_code

Line 1746: from fa_books bk

1742: , imp.SPLIT3_IMPAIR_CLASS
1743: , imp.SPLIT3_REASON
1744: , imp.SPLIT3_PERCENT
1745: , imp.SPLIT3_LOSS_ACCT -- End of Bug 6666666
1746: from fa_books bk
1747: , fa_impairments imp
1748: where imp.book_type_code = p_book_type_code
1749: and imp.status = l_mode
1750: and imp.request_id = p_request_id