APPS.PER_SHT_BUS SQL Statements

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

Line: 182

  cursor c1 is select shared_type_id
                 from per_shared_types
                where lookup_type      = p_lookup_type
                  and system_type_cd   = p_system_type_cd
                  and shared_type_code = p_shared_type_code
                  and upper(Shared_type_name) = upper(p_shared_type_name)
                  AND ((business_group_id = p_business_group_id)
				      OR (business_group_id IS NULL)
					  OR (p_business_group_id IS NULL));

Line: 209

        select hr_general.decode_lookup(p_lookup_type,p_system_type_cd) into l_lookup_code from dual;

Line: 228

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

Line: 259

End insert_validate;

Line: 264

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

Line: 295

End update_validate;

Line: 300

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

Line: 311

End delete_validate;

Line: 324

    select a.legislation_code
    from   per_business_groups a,
           per_shared_types b
    where b.shared_type_id      = p_shared_type_id
    and   a.business_group_id = b.business_group_id;