APPS.PQH_PROCESS_TENURE_STATUS dependencies on HR_LOOKUPS

Line 84: hr_lookups hl

80: and s.transaction_step_id = p_transaction_step_id
81: AND s.api_name = 'PQH_PROCESS_TENURE_STATUS.PROCESS_API'
82: )
83: ) tenure ,
84: hr_lookups hl
85: where hl.lookup_type = 'PQH_TENURE_STATUS'
86: AND hl.lookup_code = tenure.pei_information1;
87:
88: RETURN csr;