APPS.OTA_TPM_BUS1 SQL Statements

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

Line: 24

        SELECT NULL
        FROM OTA_TRAINING_PLANS
        WHERE training_plan_id    = p_training_plan_id
        AND   business_group_id   = p_business_group_id;

Line: 92

        SELECT oad.business_group_id
        FROM OTA_ACTIVITY_DEFINITIONS  oad
        WHERE oad.activity_id = p_activity_definition_id;

Line: 176

        SELECT NULL
        FROM PER_BUDGET_ELEMENTS
        WHERE training_plan_member_id = p_training_plan_member_id
        AND   training_plan_id        = p_training_plan_id;

Line: 278

         select oav.business_group_id
         from   OTA_ACTIVITY_VERSIONS_V  oav
         where  oav.activity_version_id = p_activity_version_id;*/

Line: 283

  SELECT oad.business_group_id
    FROM ota_activity_versions  oav,
         ota_activity_definitions oad
   WHERE oav.activity_id = oad.activity_id
     AND oav.activity_version_id = p_activity_version_id;

Line: 290

  SELECT oav.start_date, oav.end_date
    FROM ota_activity_versions    oav
   WHERE oav.activity_version_id = p_activity_version_id;

Line: 295

  SELECT otp.start_date, otp.end_date
    FROM ota_training_plans otp
   WHERE training_plan_id = p_training_plan_id;

Line: 298

  /*      select ptp.start_date, ptp.end_date
        from   per_time_periods ptp
              ,ota_training_plans tps
        where  tps.time_period_id   = ptp.time_period_id
        and    tps.training_plan_id = p_training_plan_id;*/

Line: 425

        SELECT NULL
        FROM OTA_ACTIVITY_DEFINITIONS  oad
            ,OTA_ACTIVITY_VERSIONS     oav
            ,OTA_TRAINING_PLAN_MEMBERS tpm
        WHERE ((oad.activity_id = p_activity_definition_id AND p_activity_definition_id IS NOT NULL)
           OR (oav.activity_version_id = p_activity_version_id AND p_activity_version_id IS NOT NULL))
        AND   oad.activity_id = oav.activity_id
        AND ( oav.activity_version_id = tpm.activity_version_id
         OR oav.activity_id = tpm.activity_definition_id )
        AND   tpm.member_status_type_id <> 'CANCELLED'
        AND   tpm.training_plan_id = p_training_plan_id
        AND (( p_training_plan_member_id IS NULL )
               OR (p_training_plan_member_id IS NOT NULL AND tpm.training_plan_member_id <> p_training_plan_member_id))
AND (
                (p_target_completion_date IS NOT NULL AND tpm.target_completion_date = p_target_completion_date)
             or p_target_completion_date is null);--

Line: 601

        SELECT NULL
        FROM OTA_TRAINING_PLAN_MEMBERS
        WHERE training_plan_id       = p_training_plan_id
        AND ( (p_activity_version_id IS NOT NULL AND
               p_activity_version_id = activity_version_id)
        OR    (p_activity_definition_id IS NOT NULL AND
               p_activity_definition_id = activity_definition_id) );

Line: 697

 SELECT 1,member_status_type_id
   FROM ota_training_plan_members
  WHERE training_plan_id       = p_training_plan_id
    AND ( (p_activity_version_id IS NOT NULL AND
        p_activity_version_id = activity_version_id)
     OR (p_activity_definition_id IS NOT NULL AND
        p_activity_definition_id = activity_definition_id))
    AND (p_target_completion_date IS NOT NULL AND
        p_target_completion_date = target_completion_date);

Line: 794

PROCEDURE chk_delete (
   p_training_plan_member_id   IN     ota_training_plan_members.training_plan_member_id%TYPE
  ,p_training_plan_id          IN     ota_training_plan_members.training_plan_id%TYPE
  )  IS
--
  l_api_updating               boolean;

Line: 801

  l_proc   VARCHAR2(72) :=      g_package|| 'chk_delete';

Line: 803

 CURSOR csr_chk_delete IS
        SELECT NULL
        FROM PER_BUDGET_ELEMENTS
        WHERE training_plan_member_id = p_training_plan_member_id
        AND   training_plan_id        = p_training_plan_id;

Line: 837

    OPEN  csr_chk_delete;

Line: 838

    FETCH csr_chk_delete INTO l_exists;

Line: 839

    IF csr_chk_delete%FOUND THEN
      CLOSE csr_chk_delete;

Line: 846

      CLOSE csr_chk_delete;

Line: 866

END chk_delete;

Line: 1007

 SELECT 1,otp.start_date,decode(otp.end_date,null,'',otp.end_date)
   FROM ota_training_plans otp
  WHERE otp.training_plan_id = p_training_plan_id
    AND ( otp.start_date > p_earliest_start_date
     OR ( otp.end_date IS NOT NULL
    AND otp.end_date < p_target_completion_date) );

Line: 1015

 SELECT NULL
   FROM ota_training_plan_members
  WHERE training_plan_id      = p_training_plan_id
    AND activity_version_id = p_activity_version_id
    AND target_completion_date >= p_earliest_start_date
    AND earliest_start_date <= p_target_completion_date
    AND member_status_type_id <> 'CANCELLED'
    and (p_training_plan_member_id is null
         or training_plan_member_id<> p_training_plan_member_id
         ) ;

Line: 1027

  SELECT oav.start_date, oav.end_date
    FROM ota_activity_versions    oav
   WHERE oav.activity_version_id = p_activity_version_id;