APPS.AHL_LTP_RESRC_LEVL_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 88

       SELECT department_id INTO l_department_id
         FROM BOM_DEPARTMENTS A, HR_ALL_ORGANIZATION_UNITS B
       WHERE A.ORGANIZATION_ID = B.ORGANIZATION_ID
        AND  B.NAME = p_x_req_resources.org_name
        AND  A.description = p_x_req_resources.dept_name;

Line: 297

       SELECT department_id INTO l_department_id
         FROM BOM_DEPARTMENTS A, HR_ALL_ORGANIZATION_UNITS B
       WHERE A.ORGANIZATION_ID = B.ORGANIZATION_ID
        AND  B.NAME = p_req_resources.org_name
        AND  A.description = p_req_resources.dept_name;