APPS.AHL_PRD_VISITS_PVT SQL Statements

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

Line: 56

      SELECT COUNT(*)
      FROM Ahl_Visit_Tasks_B
      WHERE VISIT_ID = x_id
      AND NVL(STATUS_CODE,'X') <> 'DELETED';

Line: 63

      SELECT COUNT(*)
      FROM Ahl_Visit_Tasks_B
      WHERE VISIT_ID = x_id
      AND UNIT_EFFECTIVITY_ID IS NOT NULL
      AND NVL(STATUS_CODE,'X') <> 'DELETED';

Line: 71

     SELECT MIN(T1.due_date)
     FROM ahl_unit_effectivities_vl T1, ahl_visit_tasks_b T2
     WHERE T1.unit_effectivity_id = T2.unit_effectivity_id
     AND T1.due_date IS NOT NULL AND T2.visit_id = x_id;

Line: 115

    SELECT name
    FROM ahl_unit_config_headers uc
    WHERE csi_item_instance_id in ( SELECT object_id
                                    FROM csi_ii_relationships
                                    START WITH object_id = p_csi_item_instance_id
                                    AND relationship_type_code = 'COMPONENT-OF'
                                    CONNECT BY PRIOR subject_id = object_id
                                    AND relationship_type_code = 'COMPONENT-OF'
                                  )
          and unit_config_status_code = 'COMPLETE'
          and (active_end_date is null or active_end_date > sysdate);

Line: 129

  SELECT name
    FROM ahl_unit_config_headers uc
    WHERE csi_item_instance_id = p_csi_item_instance_id
    and unit_config_status_code = 'COMPLETE' and (active_end_date is null or active_end_date > sysdate);

Line: 212

      SELECT * FROM AHL_PRD_VISITS_V
      WHERE VISIT_ID = x_id;

Line: 218

      SELECT * FROM AHL_VISITS_VL
      WHERE VISIT_ID = x_id;

Line: 224

      SELECT WORKORDER_NAME, WORKORDER_ID FROM AHL_WORKORDERS
      WHERE MASTER_WORKORDER_FLAG = 'Y' AND VISIT_ID = x_id;

Line: 231

    SELECT name
    FROM PA_PROJECTS
    WHERE project_id = p_proj_temp_id;

Line: 294

          SELECT meaning
              INTO l_project_flag
            FROM FND_LOOKUP_VALUES_VL
          WHERE lookup_code = visit_rec.project_flag
          AND LOOKUP_TYPE = 'AHL_YES_NO_TYPE';

Line: 320

             SELECT SIMULATION_PLAN_NAME
              INTO l_simulation_plan_name
            FROM AHL_SIMULATION_PLANS_VL
          WHERE SIMULATION_PLAN_ID = visit_rec.simulation_plan_id;

Line: 425

        l_visit_rec.last_update_date      :=  visit_rec.last_update_date;