APPS.PER_PERUSEOC_XMLP_PKG dependencies on HR_LOCATIONS_ALL
Line 346: HR_LOCATIONS_ALL LOC
342: FROM
343: PER_ALL_PEOPLE_F PEO,
344: PER_ASSIGNMENTS_F ASS,
345: PER_JOBS_VL JOB, 346: HR_LOCATIONS_ALL LOC 347: WHERE PEO.PERSON_ID = ASS.PERSON_ID
348: AND PEO.PER_INFORMATION1 is not null
349: AND PEO.PER_INFORMATION_CATEGORY = 'US'
350: AND JOB.JOB_INFORMATION_CATEGORY = 'US'