APPS.PQH_PROCESS_EMP_REVIEW dependencies on HR_LOCATIONS

Line 105: hr_locations loc

101: AND s.api_name = 'PQH_PROCESS_EMP_REVIEW.PROCESS_API'
102: )
103: ) review ,
104: hr_lookups hl,
105: hr_locations loc
106: where hl.lookup_type = 'EMP_INTERVIEW_TYPE'
107: AND hl.lookup_code = review.type
108: AND loc.location_id (+) = review.location_id
109: AND sysdate <= nvl(loc.inactive_date, sysdate);