APPS.FA_XML_REPORT_PKG dependencies on FA_IMPAIRMENTS

Line 269: from FA_IMPAIRMENTS

265: -- Bug#6666666 SORP Cursor c_imp and related attributes added for SORP
266: cursor c_imp(c_impairment_id number) is
267: select description,
268: impairment_date
269: from FA_IMPAIRMENTS
270: where impairment_id = c_impairment_id;
271:
272: begin
273:

Line 317: FROM FA_IMPAIRMENTS IMP

313: ,IMP.VALUE_IN_USE
314: ,IMP.GOODWILL_AMOUNT
315: ,AD.ASSET_NUMBER
316: ,IMP.IMPAIRMENT_ID
317: FROM FA_IMPAIRMENTS IMP
318: ,FA_CASH_GEN_UNITS CGU
319: ,FA_ADDITIONS_B AD
320: WHERE IMP.CASH_GENERATING_UNIT_ID = CGU.CASH_GENERATING_UNIT_ID(+)
321: AND IMP.GOODWILL_ASSET_ID = AD.ASSET_ID(+)

Line 469: (SELECT 1 FROM FA_IMPAIRMENTS IMP

465: AND ITF.BOOK_TYPE_CODE = '''||p_book_type_code||'''
466: AND NVL(ITF.cash_generating_unit_id,-99) = '''||r_CGU_id||'''
467: AND ITF.REQUEST_ID = nvl( '''||p_request_id||''', ITF.REQUEST_ID)
468: AND EXISTS
469: (SELECT 1 FROM FA_IMPAIRMENTS IMP
470: WHERE IMP.IMPAIRMENT_ID = ITF.IMPAIRMENT_ID
471: AND IMP.PERIOD_COUNTER_IMPAIRED = '''||p_period_counter||'''
472: AND IMP.STATUS = nvl( '''||p_status||''', ''POSTED''))
473: ORDER BY AD.ASSET_NUMBER'