APPS.JL_CO_FA_PURGE_PKG dependencies on FND_LOOKUPS

Line 1992: FROM jl_co_fa_appraisals apprs, fnd_lookups fl

1988: SELECT apprs.appraisal_id appraisal_id,
1989: fl.meaning appraisal_status,
1990: apprs.appraiser_name appraiser_name,
1991: apprs.appraisal_date appraisal_date
1992: FROM jl_co_fa_appraisals apprs, fnd_lookups fl
1993: WHERE apprs.fiscal_year = p_fiscal_year
1994: AND apprs.appraisal_status <> 'P'
1995: AND apprs.appraisal_status = fl.lookup_code
1996: AND fl.lookup_type = 'JLCO_FA_ASSET_APPRAISAL_STATUS'