APPS.OTA_CRT_BUS SQL Statements

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

Line: 28

    select pbg.security_group_id,
           pbg.legislation_code
      from per_business_groups_perf pbg
         , ota_certifications_b crt
     where crt.certification_id = p_certification_id
       and pbg.business_group_id = crt.business_group_id;

Line: 99

    select pbg.legislation_code
      from per_business_groups_perf pbg
         , ota_certifications_b crt
     where crt.certification_id = p_certification_id
       and pbg.business_group_id = crt.business_group_id;

Line: 324

Procedure chk_non_updateable_args
  (p_effective_date               in date
  ,p_rec in ota_crt_shd.g_rec_type
  ) IS
--
  l_proc     varchar2(72) := g_package || 'chk_non_updateable_args';

Line: 369

End chk_non_updateable_args;

Line: 385

      SELECT
         c.initial_completion_date,
         c.initial_completion_duration,
         c.renewal_duration,
         c.validity_duration,
         c.validity_start_type,
         c.renewable_flag
      FROM ota_certifications_b c
      WHERE certification_id = p_certification_id;

Line: 879

    select 'Y'
      from ota_cert_enrollments  cre
     where cre.certification_id = p_certification_id;

Line: 928

  select min(cre.enrollment_date), max(cre.enrollment_date)
  into l_min_date, l_max_date
  from ota_cert_enrollments  cre
  where cre.certification_id = p_certification_id;

Line: 966

     SELECT 'Y'
     FROM ota_certification_members m
     where m.certification_id = p_cert_id;

Line: 971

      SELECT
         min(m.start_date_active) earliest_start, max(m.end_date_active) latest_end
      FROM ota_certification_members m
      WHERE m.certification_id = p_cert_id;

Line: 1048

SELECT 'Y'
  FROM OTA_CERT_ENROLLMENTS
 where certification_id = p_certification_id;

Line: 1128

    select
          ctu.start_date_active,
          ctu.end_date_active
        from
          ota_category_usages ctu,
          ota_cert_cat_inclusions cci
        where
          ctu.category_usage_id = cci.category_usage_id
          and cci.primary_flag= 'Y'
         and cci.certification_id =  p_certification_id ;

Line: 1196

Procedure insert_validate
  (p_effective_date               in date
  ,p_rec                          in ota_crt_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 1280

End insert_validate;

Line: 1285

Procedure update_validate
  (p_effective_date               in date
  ,p_rec                          in ota_crt_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 1310

  chk_non_updateable_args
    (p_effective_date              => p_effective_date
      ,p_rec              => p_rec
    );

Line: 1389

End update_validate;

Line: 1394

Procedure delete_validate
  (p_rec                          in ota_crt_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 1407

End delete_validate;