APPS.AHL_LTP_SPACE_SCHEDULE_PVT SQL Statements

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

Line: 102

SELECT count(*)
FROM ahl_space_assignments a,
     ahl_visits_b b
WHERE a.visit_id  = c_visit_id
AND	a.visit_id = b.visit_id
AND	b.simulation_plan_id = c_plan_id
AND	a.space_id = c_space_id
AND	trunc(c_start_period) between trunc(b.start_date_time) and trunc(c_visit_end_date)
-- anraj: Consider only visits which are not simulation deleted
AND	NVL(SIMULATION_DELETE_FLAG,'N') = 'N';

Line: 121

SELECT count(*)
FROM ahl_space_assignments a,
     ahl_visits_b b
WHERE a.visit_id  = c_visit_id
AND a.visit_id = b.visit_id
AND  a.space_id = c_space_id
AND  simulation_plan_id IN (select simulation_plan_id FROM ahl_simulation_plans_vl
      WHERE primary_plan_flag = 'Y')
AND  b.visit_id NOT IN (select asso_primary_visit_id from ahl_visits_b
        WHERE simulation_plan_id = c_plan_id )
AND trunc(c_start_period) between trunc(b.start_date_time) and trunc(c_visit_end_date);

Line: 136

SELECT A.visit_id,start_date_time,
      trunc(b.close_date_time) close_date_time
FROM ahl_space_assignments a,
          ahl_visits_b B
WHERE a.visit_id = B.visit_id
AND  a.space_id = c_space_id
-- anraj:Do not consider visits which are deleted or cancelled
AND status_code NOT IN('DELETED','CANCELLED');

Line: 230

SELECT count(*)
FROM ahl_visits_b
WHERE visit_id  = c_visit_id
AND simulation_plan_id = c_plan_id
AND department_id = c_dept_id
AND trunc(c_start_period) between trunc(start_date_time) and trunc(c_visit_end_date)
-- anraj: Consider only visits which are not simulation deleted
AND NVL(SIMULATION_DELETE_FLAG,'N') = 'N';

Line: 249

SELECT count(*)
FROM ahl_visits_b
WHERE visit_id  = c_visit_id
AND  simulation_plan_id IN (select simulation_plan_id FROM ahl_simulation_plans_vl
      WHERE primary_plan_flag = 'Y')
AND  visit_id NOT IN (select asso_primary_visit_id from ahl_visits_b
        WHERE simulation_plan_id = c_plan_id )
AND trunc(c_start_period) between trunc(start_date_time) and trunc(c_visit_end_date);

Line: 261

SELECT visit_id,TRUNC(start_date_time),
       TRUNC(close_date_time)
from ahl_visits_vl
WHERE department_id = c_dept_id
AND start_date_time IS NOT NULL
-- anraj:Do not consider visits which are deleted or cancelled
AND status_code NOT IN('DELETED','CANCELLED');

Line: 357

SELECT COUNT(*)
FROM ahl_visits_b
WHERE  visit_id           = c_visit_id
AND  simulation_plan_id = c_plan_id
AND (	(	(TRUNC(start_date_time) BETWEEN trunc(c_start_date)  AND trunc(c_end_date))
OR (trunc(c_visit_end_date) BETWEEN trunc(c_start_date) AND trunc(c_end_date)))
OR ((c_start_date between trunc(start_date_time) and trunc(c_visit_end_date) )
OR trunc(c_end_date) between trunc(start_date_time) and trunc(c_visit_end_date)))
-- anraj: Consider only visits which are not simulation deleted
AND NVL(SIMULATION_DELETE_FLAG,'N') = 'N';

Line: 370

SELECT visit_id,TRUNC(start_date_time),TRUNC(close_date_time)
FROM ahl_visits_vl
WHERE department_id = c_dept_id
AND start_date_time IS NOT NULL
-- anraj:Do not consider visits which are deleted or cancelled
AND status_code NOT IN('DELETED','CANCELLED');

Line: 385

SELECT COUNT(*)
FROM ahl_visits_b
WHERE  visit_id           = c_visit_id
AND  simulation_plan_id in (select simulation_plan_id from ahl_simulation_plans_vl where primary_plan_flag = 'Y')
AND  visit_id NOT IN (select asso_primary_visit_id from ahl_visits_b WHERE simulation_plan_id = c_plan_id )
AND (	(	(TRUNC(start_date_time) BETWEEN trunc(c_start_date)  AND trunc(c_end_date))
OR (trunc(c_visit_end_date) BETWEEN trunc(c_start_date) AND trunc(c_end_date)))
OR ((c_start_date between trunc(start_date_time) and trunc(c_visit_end_date) )
OR trunc(c_end_date) between trunc(start_date_time) and trunc(c_visit_end_date)));

Line: 489

	SELECT COUNT(*)
	FROM ahl_space_assignments a,ahl_visits_b b
	WHERE  a.visit_id           = c_visit_id
	AND  a.visit_id           = b.visit_id
	AND  b.simulation_plan_id = c_plan_id
	AND  a.space_id           = c_space_id
	AND (((TRUNC(start_date_time) BETWEEN trunc(c_start_date)  AND trunc(c_end_date))
	OR (trunc(c_visit_end_date) BETWEEN trunc(c_start_date) AND trunc(c_end_date)))
	OR ((c_start_date between trunc(start_date_time) and trunc(c_visit_end_date) )
	OR trunc(c_end_date) between trunc(start_date_time) and trunc(c_visit_end_date)))
	-- anraj: Consider only visits which are not simulation deleted
	AND NVL(SIMULATION_DELETE_FLAG,'N') = 'N';

Line: 504

	SELECT	A.visit_id,
				start_date_time,
				trunc(b.close_date_time) close_date_time
   FROM ahl_space_assignments a,
          ahl_visits_b B
   WHERE a.visit_id = B.visit_id
   AND  a.space_id = c_space_id
	--anraj:Do not consider visits which are deleted or cancelled
	AND status_code NOT IN('DELETED','CANCELLED');

Line: 523

SELECT COUNT(*)
FROM ahl_space_assignments a,ahl_visits_b b
WHERE  a.visit_id           = c_visit_id
AND  a.visit_id           = b.visit_id
AND  b.simulation_plan_id in (select simulation_plan_id
	 from ahl_simulation_plans_vl where primary_plan_flag = 'Y')
AND  b.visit_id NOT IN (select asso_primary_visit_id from ahl_visits_b
     WHERE simulation_plan_id = c_plan_id )
AND  a.space_id           = c_space_id
AND (((TRUNC(start_date_time) BETWEEN trunc(c_start_date)  AND trunc(c_end_date))
OR (trunc(c_visit_end_date) BETWEEN trunc(c_start_date) AND trunc(c_end_date)))
OR ((c_start_date between trunc(start_date_time) and trunc(c_visit_end_date) )
OR trunc(c_end_date) between trunc(start_date_time) and trunc(c_visit_end_date)));

Line: 637

 SELECT space_unavailability_id
  FROM ahl_space_unavailable_b
WHERE space_id = c_space_id
  AND (trunc(start_date) between c_start_date and c_end_date
     or trunc(end_date) between c_start_date and c_end_date);

Line: 677

          SELECT lookup_code INTO x_lookup_code
           FROM FND_LOOKUP_VALUES_VL
          WHERE lookup_type = p_lookup_type
            AND lookup_code = p_lookup_code
            AND SYSDATE BETWEEN start_date_active
            AND NVL(end_date_active,SYSDATE);

Line: 687

          SELECT lookup_code INTO x_lookup_code
           FROM FND_LOOKUP_VALUES_VL
          WHERE lookup_type = p_lookup_type
            AND meaning     = p_meaning
            AND SYSDATE BETWEEN start_date_active
            AND NVL(end_date_active,SYSDATE);

Line: 723

	SELECT space_id
		FROM AHL_SPACE_UNAVAILABLE_B
   WHERE space_id = c_space_id
   AND trunc(c_date) between trunc(start_date) and trunc(end_date);

Line: 764

		--SELECT Clause
		l_sql_string := 'select distinct(a.department_id),b.description, b.department_code,c.name';

Line: 769

   l_sql_string := l_sql_string || ' where visit_id not in (select visit_id from ahl_space_assignments)';

Line: 799

		l_sql_string := l_sql_string || ' UNION  select	b.department_id, b.description, b.department_code, c.name ' ;

Line: 820

		l_sql_string := l_sql_string || ' ( select unique department_id from ahl_visits_b' ;

Line: 827

		l_sql_string := l_sql_string || ' AND visit_id NOT IN (SELECT visit_id FROM ahl_space_assignments))';

Line: 828

		l_sql_string := l_sql_string || ' and 	exists ( SELECT ''x'' FROM AHL_DEPARTMENT_SHIFTS WHERE DEPARTMENT_ID = B.DEPARTMENT_ID) ' ;

Line: 839

   l_sql_string1 := ' SELECT distinct(a.space_id), space_name, space_category, meaning,';

Line: 1818

   l_sql_string := 'select distinct(a.department_id),b.description, b.department_code,c.name';

Line: 1822

   l_sql_string := l_sql_string || ' where visit_id not in (select visit_id from ahl_space_assignments)';

Line: 1852

		l_sql_string := l_sql_string || ' UNION  select	b.department_id, b.description, b.department_code, c.name ' ;

Line: 1874

		l_sql_string := l_sql_string || ' ( select unique department_id from ahl_visits_b' ;

Line: 1881

		l_sql_string := l_sql_string || ' AND visit_id NOT IN (SELECT visit_id FROM ahl_space_assignments))';

Line: 1882

		l_sql_string := l_sql_string || ' and 	exists ( SELECT ''x'' FROM AHL_DEPARTMENT_SHIFTS WHERE DEPARTMENT_ID = B.DEPARTMENT_ID) ' ;

Line: 1893

   l_sql_string1 := ' SELECT distinct(a.space_id), space_name, space_category, meaning,';

Line: 2885

   l_sql_string := 'select distinct(a.department_id),b.description, b.department_code,c.name';

Line: 2889

   l_sql_string := l_sql_string || ' where visit_id not in (select visit_id from ahl_space_assignments)';

Line: 2939

   l_sql_string1 := ' SELECT distinct(a.space_id), space_name, space_category, meaning,';

Line: 2987

		l_sql_string := l_sql_string || ' UNION  select	b.department_id, b.description, b.department_code, c.name ' ;

Line: 3008

		l_sql_string := l_sql_string || ' ( select unique department_id from ahl_visits_b' ;

Line: 3015

		l_sql_string := l_sql_string || ' AND visit_id NOT IN (SELECT visit_id FROM ahl_space_assignments))';

Line: 3016

		l_sql_string := l_sql_string || ' and 	exists ( SELECT ''x'' FROM AHL_DEPARTMENT_SHIFTS WHERE DEPARTMENT_ID = B.DEPARTMENT_ID) ' ;

Line: 3037

            SELECT ADD_MONTHS(x_display_rec.start_period_1,1) INTO
            x_display_rec.end_period_1 FROM DUAL;

Line: 3068

            SELECT ADD_MONTHS(x_display_rec.start_period_2,1) INTO
            x_display_rec.end_period_2 FROM DUAL;

Line: 3098

            SELECT ADD_MONTHS(x_display_rec.start_period_3,1) INTO
            x_display_rec.end_period_3 FROM DUAL;

Line: 3128

            SELECT ADD_MONTHS(x_display_rec.start_period_4,1) INTO
            x_display_rec.end_period_4 FROM DUAL;

Line: 3158

            SELECT ADD_MONTHS(x_display_rec.start_period_5,1) INTO
            x_display_rec.end_period_5 FROM DUAL;

Line: 3186

            SELECT ADD_MONTHS(x_display_rec.start_period_6,1) INTO
            x_display_rec.end_period_6 FROM DUAL;

Line: 3214

            SELECT ADD_MONTHS(x_display_rec.start_period_7,1) INTO
            x_display_rec.end_period_7 FROM DUAL;

Line: 3242

            SELECT ADD_MONTHS(x_display_rec.start_period_8,1) INTO
            x_display_rec.end_period_8 FROM DUAL;

Line: 3270

            SELECT ADD_MONTHS(x_display_rec.start_period_9,1) INTO
            x_display_rec.end_period_9 FROM DUAL;

Line: 3298

            SELECT ADD_MONTHS(x_display_rec.start_period_10,1) INTO
            x_display_rec.end_period_10 FROM DUAL;

Line: 3326

            SELECT ADD_MONTHS(x_display_rec.start_period_11,1) INTO
            x_display_rec.end_period_11 FROM DUAL;

Line: 3354

            SELECT ADD_MONTHS(x_display_rec.start_period_12,1) INTO
            x_display_rec.end_period_12 FROM DUAL;

Line: 3382

            SELECT ADD_MONTHS(x_display_rec.start_period_13,1) INTO
            x_display_rec.end_period_13 FROM DUAL;

Line: 3410

            SELECT ADD_MONTHS(x_display_rec.start_period_14,1) INTO
            x_display_rec.end_period_14 FROM DUAL;

Line: 3469

            SELECT ADD_MONTHS(x_display_rec.start_period_1,1) INTO
            x_display_rec.end_period_1 FROM DUAL;

Line: 3507

            SELECT ADD_MONTHS(x_display_rec.start_period_2,1) INTO
            x_display_rec.end_period_2 FROM DUAL;

Line: 3544

            SELECT ADD_MONTHS(x_display_rec.start_period_3,1) INTO
            x_display_rec.end_period_3 FROM DUAL;

Line: 3580

            SELECT ADD_MONTHS(x_display_rec.start_period_4,1) INTO
            x_display_rec.end_period_4 FROM DUAL;

Line: 3616

            SELECT ADD_MONTHS(x_display_rec.start_period_5,1) INTO
            x_display_rec.end_period_5 FROM DUAL;

Line: 3650

            SELECT ADD_MONTHS(x_display_rec.start_period_6,1) INTO
            x_display_rec.end_period_6 FROM DUAL;

Line: 3684

            SELECT ADD_MONTHS(x_display_rec.start_period_7,1) INTO
            x_display_rec.end_period_7 FROM DUAL;

Line: 3718

            SELECT ADD_MONTHS(x_display_rec.start_period_8,1) INTO
            x_display_rec.end_period_8 FROM DUAL;

Line: 3752

            SELECT ADD_MONTHS(x_display_rec.start_period_9,1) INTO
            x_display_rec.end_period_9 FROM DUAL;

Line: 3786

            SELECT ADD_MONTHS(x_display_rec.start_period_10,1) INTO
            x_display_rec.end_period_10 FROM DUAL;

Line: 3820

            SELECT ADD_MONTHS(x_display_rec.start_period_11,1) INTO
            x_display_rec.end_period_11 FROM DUAL;

Line: 3854

            SELECT ADD_MONTHS(x_display_rec.start_period_12,1) INTO
            x_display_rec.end_period_12 FROM DUAL;

Line: 3888

            SELECT ADD_MONTHS(x_display_rec.start_period_13,1) INTO
            x_display_rec.end_period_13 FROM DUAL;

Line: 3922

            SELECT ADD_MONTHS(x_display_rec.start_period_14,1) INTO
            x_display_rec.end_period_14 FROM DUAL;

Line: 4017

 SELECT simulation_plan_id,
        primary_plan_flag
   FROM  ahl_simulation_plans_vl
  WHERE simulation_plan_id = c_plan_id;

Line: 4025

   SELECT organization_id,name
     FROM hr_all_organization_units
   WHERE (organization_id = c_org_id
         OR name = c_name);

Line: 4036

      SELECT   distinct(inventory_item_id)
      FROM     MTL_SYSTEM_ITEMS_VL
      WHERE    (inventory_item_id      = c_item_id OR concatenated_segments  = c_item_description);

Line: 4042

      SELECT   distinct(inventory_item_id)
      FROM     MTL_SYSTEM_ITEMS_VL
      WHERE    inventory_item_id  = c_item_id;

Line: 4048

      SELECT   distinct(inventory_item_id)
      FROM     MTL_SYSTEM_ITEMS_VL
      WHERE    concatenated_segments  = c_item_description;

Line: 4058

  SELECT 1 FROM ahl_space_capabilities
   WHERE visit_type = c_visit_type
     AND inventory_item_id = c_item_id
     AND space_id = c_space_id;

Line: 4430

            SELECT ADD_MONTHS(x_display_rec.start_period_1,1) INTO
            x_display_rec.end_period_1 FROM DUAL;

Line: 4438

           SELECT ADD_MONTHS(l_start_date,1) INTO
           x_display_rec.end_period_1 FROM DUAL;

Line: 4443

           SELECT ADD_MONTHS(x_display_rec.end_period_1,1) INTO
           x_display_rec.end_period_2 FROM DUAL;

Line: 4448

           SELECT ADD_MONTHS(x_display_rec.end_period_2,1) INTO
           x_display_rec.end_period_3 FROM DUAL;

Line: 4453

           SELECT ADD_MONTHS(x_display_rec.end_period_3,1) INTO
           x_display_rec.end_period_4 FROM DUAL;

Line: 4458

           SELECT ADD_MONTHS(x_display_rec.end_period_4,1) INTO
           x_display_rec.end_period_5 FROM DUAL;

Line: 4463

           SELECT ADD_MONTHS(x_display_rec.end_period_5,1) INTO
           x_display_rec.end_period_6 FROM DUAL;

Line: 4468

           SELECT ADD_MONTHS(x_display_rec.end_period_6,1) INTO
           x_display_rec.end_period_7 FROM DUAL;

Line: 4473

           SELECT ADD_MONTHS(x_display_rec.end_period_7,1) INTO
           x_display_rec.end_period_8 FROM DUAL;

Line: 4478

           SELECT ADD_MONTHS(x_display_rec.end_period_8,1) INTO
           x_display_rec.end_period_9 FROM DUAL;

Line: 4483

           SELECT ADD_MONTHS(x_display_rec.end_period_9,1) INTO
           x_display_rec.end_period_10 FROM DUAL;

Line: 4488

           SELECT ADD_MONTHS(x_display_rec.end_period_10,1) INTO
           x_display_rec.end_period_11 FROM DUAL;

Line: 4493

           SELECT ADD_MONTHS(x_display_rec.end_period_11,1) INTO
           x_display_rec.end_period_12 FROM DUAL;

Line: 4498

           SELECT ADD_MONTHS(x_display_rec.end_period_12,1) INTO
           x_display_rec.end_period_13 FROM DUAL;

Line: 4596

   SELECT start_date_time
      FROM AHL_VISITS_B
    WHERE visit_id = c_visit_id;

Line: 4603

   SELECT max(end_date_time)
     FROM ahl_visit_tasks_vl
    WHERE visit_id = c_visit_id
	and status_code <> 'DELETED' ;

Line: 4777

   SELECT start_date_time
      FROM AHL_VISITS_B
    WHERE visit_id = c_visit_id;

Line: 4783

   SELECT max(end_date_time)
     FROM ahl_visit_tasks_vl
    WHERE visit_id = c_visit_id;

Line: 4939

      SELECT COUNT(*)
      FROM Ahl_Visit_Tasks_B
      WHERE VISIT_ID = x_id;

Line: 4945

      SELECT COUNT(*)
      FROM Ahl_Visit_Tasks_B
      WHERE VISIT_ID = x_id AND UNIT_EFFECTIVITY_ID IS NOT NULL;

Line: 4951

     SELECT MAX(T1.due_date)
     FROM ahl_unit_effectivities_app_v T1, ahl_visit_tasks_b T2
     WHERE T1.unit_effectivity_id = T2.unit_effectivity_id AND T2.visit_id = x_id;

Line: 5255

SELECT   VST.visit_id,
         VST.visit_number,
         VST.visit_name,
         VST.status_code,
         CSI.serial_number,
         AHL_UTILITY_PVT.GET_UNIT_NAME(VST.ITEM_INSTANCE_ID) unit_name,
         mtl.CONCATENATED_SEGMENTS item_description,
         FLVT.MEANING visit_type_mean,
         trunc(VST.start_date_time) start_date_time,
         trunc(VST.CLOSE_DATE_TIME) close_date_time,
         (
            SELECT   MAX(DUE_DATE)
            FROM     AHL_UNIT_EFFECTIVITIES_B A,
                     AHL_VISIT_TASKS_B B
            WHERE    A.UNIT_EFFECTIVITY_ID = B.UNIT_EFFECTIVITY_ID
            AND      B.VISIT_ID = VST.VISIT_ID
            GROUP BY VISIT_ID
         ) due_by
FROM     AHL_VISITS_VL VST,
         CSI_ITEM_INSTANCES CSI ,
         MTL_SYSTEM_ITEMS_B_KFV mtl,
         FND_LOOKUP_VALUES_VL FLVT,
         ahl_space_assignments SPS
where    VST.ITEM_INSTANCE_ID = CSI.INSTANCE_ID(+)
and      VST.INVENTORY_ITEM_ID = mtl.INVENTORY_ITEM_ID(+)
AND      VST.ITEM_ORGANIZATION_ID = mtl.ORGANIZATION_ID(+)
AND      FLVT.LOOKUP_TYPE(+) = 'AHL_PLANNING_VISIT_TYPE'
AND      FLVT.LOOKUP_CODE(+) = VST.VISIT_TYPE_CODE
AND      VST.visit_id = SPS.visit_id
AND      SPS.space_id = c_space_id;

Line: 5292

  SELECT    VST.visit_id,
            VST.visit_number,
            VST.visit_name,
            VST.status_code,
            CSI.serial_number,
            AHL_UTILITY_PVT.GET_UNIT_NAME(VST.ITEM_INSTANCE_ID) unit_name,
            mtl.CONCATENATED_SEGMENTS item_description,
            FLVT.MEANING visit_type_mean,
            trunc(VST.start_date_time) start_date_time,
            trunc(VST.CLOSE_DATE_TIME) close_date_time,
            (
               SELECT   MAX(DUE_DATE)
               FROM     AHL_UNIT_EFFECTIVITIES_B A,
                        AHL_VISIT_TASKS_B B
               WHERE    A.UNIT_EFFECTIVITY_ID = B.UNIT_EFFECTIVITY_ID
               AND      B.VISIT_ID = VST.VISIT_ID
               GROUP BY VISIT_ID
            ) due_by
   FROM     AHL_VISITS_VL VST,
            CSI_ITEM_INSTANCES CSI ,
            MTL_SYSTEM_ITEMS_B_KFV mtl,
            FND_LOOKUP_VALUES_VL FLVT
   where    VST.ITEM_INSTANCE_ID = CSI.INSTANCE_ID(+)
   and      VST.INVENTORY_ITEM_ID = mtl.INVENTORY_ITEM_ID(+)
   AND      VST.ITEM_ORGANIZATION_ID = mtl.ORGANIZATION_ID(+)
   AND      FLVT.LOOKUP_TYPE(+) = 'AHL_PLANNING_VISIT_TYPE'
   AND      FLVT.LOOKUP_CODE(+) = VST.VISIT_TYPE_CODE
   AND      VST.department_id = c_dept_id;

Line: 5328

 SELECT distinct(a.visit_id) visit_id,
        a.visit_number,
        serial_number,
		b.status_code,
        item_description,
		b.visit_name,
		unit_name,
		b.simulation_plan_id,
        visit_type_mean,
        a.start_date_time, due_by,
		trunc(b.close_date_time) close_date_time
  FROM ahl_visit_details_v a , ahl_visits_vl b
  WHERE a.visit_id = c_visit_id
    AND a.visit_id = b.visit_id
    AND a.simulation_plan_id = c_plan_id
    AND (((trunc(b.start_date_time) between trunc(c_start_period) and trunc(c_end_period))
	 OR
	   (trunc(c_visit_end_date) between trunc(c_start_period) and trunc(c_end_period) ))

	OR ((trunc(c_start_period) between trunc(b.start_date_time) and trunc(c_visit_end_date))
	 OR
	    (trunc(c_end_period) between trunc(b.start_date_time) and trunc(c_visit_end_date))))
	--Added by mpothuku on 03/29 to fix issue #203 in forum
	AND (nvl(b.simulation_delete_flag, 'N') <> 'Y')
	AND b.status_code not in ('CANCELLED', 'DELETED');

Line: 5361

 SELECT DISTINCT(a.visit_id) visit_id,
        b.visit_number,
        serial_number,
		b.status_code,
        item_description,
		b.visit_name,
		unit_name,
		b.simulation_plan_id,
        visit_type_mean,
        b.start_date_time, due_by,
		trunc(b.CLOSE_DATE_TIME) close_date_time
  FROM ahl_visit_details_v a ,
       ahl_visits_vl b
  WHERE a.visit_id = b.visit_id
    AND a.simulation_plan_id in (select simulation_plan_id
        from ahl_simulation_plans_vl where primary_plan_flag = 'Y')
    AND a.visit_id = c_visit_id
    AND  b.visit_id NOT IN (select asso_primary_visit_id from ahl_visits_b
        WHERE simulation_plan_id = c_plan_id )
    AND (((trunc(b.start_date_time) between trunc(c_start_period) and trunc(c_end_period))
	 OR
	   (trunc(c_visit_end_date) between trunc(c_start_period) and trunc(c_end_period) ))


	OR ((trunc(c_start_period) between trunc(b.start_date_time) and trunc(c_visit_end_date))
	 OR
    (trunc(c_end_period) between trunc(b.start_date_time) and trunc(c_visit_end_date))))

	--Added by mpothuku on 03/29 to fix issue #203 in forum
	AND b.status_code not in ('CANCELLED', 'DELETED');

Line: 5395

 SELECT simulation_plan_id,
        primary_plan_flag
   FROM  ahl_simulation_plans_vl
  WHERE simulation_plan_id = c_plan_id;

Line: 5403

   SELECT organization_id,name
     FROM hr_all_organization_units
   WHERE (organization_id = c_org_id
         OR name = c_name);

Line: 5412

   SELECT department_id,department_code,description
     FROM bom_departments
   WHERE organization_id = c_org_id
     AND (department_id = c_dept_id
	   OR description   = c_dept_name);

Line: 5422

   SELECT space_id,space_name
     FROM AHL_SPACES_VL
   WHERE bom_department_id = c_dept_id
     AND (space_id         = c_space_id
	   OR space_name       = c_space_name);

Line: 5432

 SELECT visit_id, visit_name, visit_type_code,
        trunc(start_date_time) start_date_time,
		trunc(close_date_time) close_date_time
  FROM ahl_visits_vl
 WHERE department_id = c_dept_id
   AND start_date_time IS NOT NULL;

Line: 5445

   SELECT distinct(inventory_item_id),concatenated_segments
     FROM MTL_SYSTEM_ITEMS_VL
   WHERE (inventory_item_id   = c_item_id
	   OR concatenated_segments     = c_item_description);

Line: 5452

   SELECT   distinct(inventory_item_id),concatenated_segments
   FROM     MTL_SYSTEM_ITEMS_VL
   WHERE    concatenated_segments     = c_item_description;

Line: 5458

   SELECT   distinct(inventory_item_id),concatenated_segments
   FROM     MTL_SYSTEM_ITEMS_VL
   WHERE    inventory_item_id   = c_item_id;

Line: 5767

		    select count(*) into l_count from ahl_space_assignments
			  where visit_id = l_visit_wd_detail_rec.visit_id;

Line: 5770

			SELECT primary_plan_flag INTO x_visit_details_tbl(i).plan_flag
			     FROM ahl_simulation_plans_vl
				 WHERE simulation_plan_id =  l_visit_wd_detail_rec.simulation_plan_id;

Line: 5828

		    select count(*) into l_count from ahl_space_assignments
			  where visit_id = l_visit_wd1_detail_rec.visit_id;

Line: 5831

			SELECT primary_plan_flag INTO x_visit_details_tbl(i).plan_flag
			     FROM ahl_simulation_plans_vl
				 WHERE simulation_plan_id =  l_visit_wd1_detail_rec.simulation_plan_id;

Line: 5863

		    select count(*) into l_count from ahl_space_assignments
			  where visit_id = l_visit_wd_detail_rec.visit_id;

Line: 5866

			SELECT primary_plan_flag INTO x_visit_details_tbl(i).plan_flag
			     FROM ahl_simulation_plans_vl
				 WHERE simulation_plan_id =  l_visit_wd_detail_rec.simulation_plan_id;

Line: 5942

           SELECT primary_plan_flag INTO x_visit_details_tbl(i).plan_flag
                    FROM ahl_simulation_plans_vl
           WHERE simulation_plan_id =  l_visit_wd_detail_rec.simulation_plan_id;

Line: 5997

			SELECT primary_plan_flag INTO x_visit_details_tbl(i).plan_flag
			     FROM ahl_simulation_plans_vl
				 WHERE simulation_plan_id =  l_visit_wd1_detail_rec.simulation_plan_id;

Line: 6023

		   SELECT primary_plan_flag INTO x_visit_details_tbl(i).plan_flag
			    FROM ahl_simulation_plans_vl
 		 WHERE simulation_plan_id =  l_visit_wd_detail_rec.simulation_plan_id;

Line: 6137

   SELECT start_date_time
      FROM AHL_VISITS_B
    WHERE visit_id = c_visit_id;

Line: 6143

   SELECT max(end_date_time)
     FROM ahl_visit_tasks_vl
    WHERE visit_id = c_visit_id;