DBA Data[Home] [Help]

APPS.PQH_PROCESS_EMP_REVIEW dependencies on HR_LOOKUPS

Line 104: hr_lookups hl,

100: AND s.transaction_step_id = p_transaction_step_id
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