APPS.AHL_UTIL_UC_PKG dependencies on WIP_ENTITIES

Line 113: FROM csi_lookups f, hr_all_organization_units hou, wip_entities wip_ent

109:
110: -- if location is WIP.
111: CURSOR wip_entity_csr(p_wip_job_id IN NUMBER) IS
112: SELECT f.meaning || ';' || hou.name
113: FROM csi_lookups f, hr_all_organization_units hou, wip_entities wip_ent
114: WHERE wip_ent.organization_id = hou.organization_id
115: AND wip_ent.wip_entity_id = p_wip_job_id
116: AND f.lookup_code = 'WIP'
117: AND f.lookup_type = 'CSI_INST_LOCATION_SOURCE_CODE';