APPS.PQH_DEL_BUS SQL Statements

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

Line: 110

    select null
    from   pqh_dflt_budget_sets a
    where  a.dflt_budget_set_id = p_dflt_budget_set_id;

Line: 164

 select 'X'
 from pqh_dflt_budget_elements
 where dflt_budget_set_id = p_dflt_budget_set_id
   and dflt_budget_element_id <> nvl(p_dflt_budget_element_id,0)
   and element_type_id   = p_element_type_id;

Line: 201

 select SUM(NVL(dflt_dist_percentage,0))
 from pqh_dflt_budget_elements
 where dflt_budget_set_id = p_dflt_budget_set_id;

Line: 255

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

Line: 283

End insert_validate;

Line: 288

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

Line: 317

End update_validate;

Line: 322

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

Line: 332

End delete_validate;