APPS.OTA_NHS_BUS SQL Statements

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

Line: 22

    select pbg.security_group_id
      from per_business_groups pbg
         , ota_notrng_histories nth
     where nth.nota_history_id = p_nota_history_id
       and pbg.business_group_id = nth.business_group_id;

Line: 83

    select pbg.legislation_code
      from per_business_groups pbg
         , ota_notrng_histories nth
     where nth.nota_history_id = p_nota_history_id
       and pbg.business_group_id = nth.business_group_id;

Line: 310

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

Line: 366

End chk_non_updateable_args;

Line: 388

     select null
     from hr_all_organization_units
     where organization_id = p_organization_id and
           business_group_id = p_business_group_id;

Line: 394

     select null
     from hr_all_organization_units
     where organization_id = p_organization_id ;

Line: 456

     Select null
     From HZ_PARTIES party,
          HZ_CUST_ACCOUNTS cust_acct
          Where CUST_ACCT.party_id = PARTY.party_id
          and CUST_ACCT.cust_account_id=p_customer_id;

Line: 508

   Select null
   From HZ_CUST_ACCOUNT_ROLES acct_role,
             HZ_RELATIONSHIPS rel,
             HZ_CUST_ACCOUNTS role_acct
   where acct_role.party_id = rel.party_id
  and acct_role.role_type = 'CONTACT'
  and rel.subject_table_name = 'HZ_PARTIES'
  and rel.object_table_name = 'HZ_PARTIES'
  and  acct_role.cust_account_id = role_acct.cust_account_id
  and  role_acct.party_id  =  rel.object_id
  and ACCT_ROLE.cust_account_role_id=p_person_id
  and ACCT_ROLE.cust_account_id=p_customer_id;

Line: 525

     select null
     from per_all_people_f per
     where per.business_group_id = p_business_group_id and
          per.person_id = p_person_id and
          rownum=1;

Line: 537

     select null
     from per_all_people_f per
     where  per.person_id = p_person_id
     and rownum=1;

Line: 627

     Select null
     From HZ_CUST_ACCOUNT_ROLES acct_role,
             HZ_RELATIONSHIPS rel,
             HZ_CUST_ACCOUNTS role_acct
  where acct_role.party_id = rel.party_id
  and acct_role.role_type = 'CONTACT'
  and rel.subject_table_name = 'HZ_PARTIES'
  and rel.object_table_name = 'HZ_PARTIES'
  and  acct_role.cust_account_id = role_acct.cust_account_id
  and  role_acct.party_id  =  rel.object_id
  and ACCT_ROLE.cust_account_role_id=p_contact_id
  and ACCT_ROLE.cust_account_id=p_customer_id;

Line: 644

     select null
     from per_all_people_f
     where person_id = p_contact_id and
           p_effective_date between effective_start_date and
            effective_end_date  ;

Line: 918

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

Line: 974

End insert_validate;

Line: 979

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

Line: 992

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

Line: 1041

End update_validate;

Line: 1046

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

Line: 1056

End delete_validate;