APPS.HR_EDW_WRK_CMPSTN_F_C dependencies on FND_CURRENCIES_VL

Line 593: FROM hr_edw_wrk_cmpstn_fstg a, fnd_currencies_vl b

589: snapshot_date
590: ,rpad(b.name,20) currency_name
591: ,b.currency_code currency_code
592: ,count(*) total
593: FROM hr_edw_wrk_cmpstn_fstg a, fnd_currencies_vl b
594: WHERE a.currency_fk = b.currency_code (+)
595: AND a.collection_status IN ('INVALID_CURRENCY','RATE_NOT_AVAILABLE')
596: GROUP BY a.collection_status, a.snapshot_date, b.name, b.currency_code
597: ORDER BY 1,2,3;