APPS.PJM_PROJTASK_DELETION SQL Statements

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

Line: 45

       SELECT  1
       FROM dual
       WHERE
           EXISTS (
               SELECT 1
               FROM pjm_project_parameters ppp
               WHERE  ppp.project_id = l_project_id
               --
               -- Bug 917915: should only return value if p_task_id is
               -- null
               AND    p_task_id is null
           );

Line: 58

       SELECT  1
       FROM dual
       WHERE
           EXISTS (
               SELECT 1
               FROM oe_order_lines_all ool
               WHERE  ool.project_id = l_project_id
               AND  ool.task_id =  NVL(p_task_id, ool.task_id)
           );

Line: 68

       SELECT  1
       FROM dual
       WHERE
           EXISTS (
               SELECT 1
               FROM wip_discrete_jobs job
               WHERE  job.project_id = l_project_id
               AND   job.task_id = NVL(p_task_id, job.task_id)
           );

Line: 78

       SELECT  1
       FROM dual
       WHERE
           EXISTS (
               SELECT 1
               FROM mtl_item_locations loc
               WHERE loc.project_id = l_project_id
               AND  loc.task_id = NVL(p_task_id, loc.task_id)
           );

Line: 88

       SELECT  1
       FROM dual
       WHERE
           EXISTS (
               SELECT 1
               FROM mtl_material_transactions mmt
               WHERE (mmt.source_project_id = l_project_id
                   AND mmt.source_task_Id = NVL(p_task_id, mmt.source_task_id)
                   ) );

Line: 98

       SELECT  1
       FROM dual
       WHERE
           EXISTS (
               SELECT 1
               FROM mrp_forecast_dates frct
               WHERE frct.project_id = l_project_id
                   AND frct.task_id = NVL(p_task_id, frct.task_id)
           );

Line: 108

       SELECT  1
       FROM dual
       WHERE
           EXISTS (
               SELECT 1
               FROM mrp_schedule_dates schd
               WHERE schd.project_id = l_project_id
                   AND schd.task_id = NVL(p_task_id, schd.task_id)
           );

Line: 118

       SELECT  1
       FROM dual
       WHERE
           EXISTS (
               SELECT 1
               FROM po_distributions_all dist
               WHERE dist.project_id = l_project_id
                 AND dist.task_id = NVL(p_task_id, dist.task_id)
              );

Line: 128

       SELECT  1
       FROM dual
       WHERE
           EXISTS (
               SELECT 1
               FROM po_req_distributions_all rdist
               WHERE rdist.project_id = l_project_id
                 AND rdist.task_id =  NVL(p_task_id, rdist.task_id)
	   );

Line: 139

       SELECT 1
       FROM dual
       WHERE
           EXISTS (
               SELECT 1
               FROM wip_transactions wip
               WHERE wip.project_id = l_project_id
                 AND wip.task_id = NVL(p_task_id, wip.task_id)
              );

Line: 150

       SELECT  1
       FROM dual
       WHERE
           EXISTS (
               SELECT 1
               FROM mtl_material_transactions mmt
               WHERE (mmt.project_id = l_project_id
                   AND mmt.task_id = NVL(p_task_id, mmt.task_id)
                  ));

Line: 161

       SELECT  1
       FROM dual
       WHERE
           EXISTS (
               SELECT 1
               FROM mtl_material_transactions mmt
               WHERE (mmt.project_id = l_project_id
                   AND mmt.to_task_id = NVL(p_task_id, mmt.to_task_id)
                  ));

Line: 173

    SELECT decode(count(1),0,0,1)
    INTO   pjm_active
    FROM   pjm_org_parameters
    WHERE  project_reference_enabled = 'Y';

Line: 184

           SELECT tsk.project_id
           INTO   l_project_id
           FROM   pa_tasks tsk
           WHERE  task_id = p_task_id;

Line: 279

         SELECT 2
         INTO l_dummy
         FROM dual
         WHERE EXISTS (
               SELECT 1
               FROM pjm_default_tasks pjm
               WHERE pjm.project_id = l_project_id
                 AND pjm.task_id =  NVL(p_task_id, pjm.task_id)
           );

Line: 332

     SELECT  1
     INTO    retcode
     FROM    dual
     WHERE
         EXISTS (
             SELECT 1
             FROM oe_order_lines_all ool
             WHERE  ool.project_id = p_project_id
             AND    ool.ship_from_org_id = p_org_id
         ) OR
         EXISTS (
             SELECT 1
             FROM wip_discrete_jobs job
             WHERE  job.project_id = p_project_id
             AND    job.organization_id = p_org_id
         ) OR
         EXISTS (
             SELECT 1
             FROM mtl_item_locations loc
             WHERE loc.project_id = p_project_id
             AND   loc.organization_id = p_org_id
         ) OR
         EXISTS (
             SELECT 1
             FROM mtl_material_transactions mmt
             WHERE (mmt.project_id = p_project_id
                   AND mmt.organization_id = p_org_id
                )
             OR (mmt.to_project_id = p_project_id
                 AND mmt.transfer_organization_id = p_org_id
                 )
             OR (mmt.source_project_id = p_project_id
                 AND mmt.organization_id = p_org_id
                 )
         ) OR
         EXISTS (
             SELECT 1
             FROM mrp_forecast_dates frct
             WHERE frct.project_id = p_project_id
             AND   frct.organization_id = p_org_id
         ) OR
         EXISTS (
             SELECT 1
             FROM mrp_schedule_dates schd
             WHERE schd.project_id = p_project_id
             AND   schd.organization_id = p_org_id
         ) OR
         EXISTS (
             SELECT 1
             FROM po_distributions_all dist
             WHERE dist.project_id = p_project_id
             AND   dist.destination_organization_id = p_org_id
            ) OR
         EXISTS (
             SELECT 1
             FROM po_req_distributions_all rdist
             ,    po_requisition_lines_all rline
             WHERE rdist.project_id = p_project_id
             AND   rline.requisition_line_id = rdist.requisition_line_id
             AND   rline.destination_organization_id = p_org_id
         );