APPS.PER_BIL_BUS SQL Statements

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

Line: 79

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

Line: 140

End insert_validate;

Line: 145

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

Line: 209

End update_validate;

Line: 214

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

Line: 220

    select type
    from   hr_summary
    where  (fk_value1 = p_rec.id_value
    or      fk_value2 = p_rec.id_value
    or      fk_value3 = p_rec.id_value);

Line: 257

End delete_validate;

Line: 270

    select a.legislation_code
    from   per_business_groups a,
           hr_summary b
    where b.id_value      = p_id_value
    and   a.business_group_id = b.business_group_id;