APPS.AHL_VWP_TASKS_PUB SQL Statements

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

Line: 191

 SELECT organization_id FROM ahl_visits_b
 WHERE visit_id = c_visit_id
   AND status_code in ('RELEASED', 'PLANNING', 'PARTIALLY RELEASED');

Line: 196

 SELECT visit_id, organization_id FROM ahl_visits_b
 WHERE visit_number = c_visit_number
   AND status_code in ('RELEASED', 'PLANNING', 'PARTIALLY RELEASED');

Line: 201

 SELECT department_id FROM bom_departments
 WHERE department_id = c_dept_id
   AND organization_id = c_org_id;

Line: 206

 SELECT department_id FROM bom_departments
 WHERE department_code = c_dept_code
   AND organization_id = c_org_id;

Line: 211

  SELECT 1 from AHL_UE_RELATIONSHIPS
  WHERE RELATED_UE_ID = c_ue_id;