APPS.JL_CO_FA_PURGE_PKG dependencies on FND_LOOKUPS

Line 1977: FROM jl_co_fa_appraisals apprs, fnd_lookups fl

1973: SELECT apprs.appraisal_id appraisal_id,
1974: fl.meaning appraisal_status,
1975: apprs.appraiser_name appraiser_name,
1976: apprs.appraisal_date appraisal_date
1977: FROM jl_co_fa_appraisals apprs, fnd_lookups fl
1978: WHERE apprs.fiscal_year = p_fiscal_year
1979: AND apprs.appraisal_status <> 'P'
1980: AND apprs.appraisal_status = fl.lookup_code
1981: AND fl.lookup_type = 'JLCO_FA_ASSET_APPRAISAL_STATUS'