APPS.PQH_RLT_BUS SQL Statements

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

Line: 112

  select 'x'
  from pqh_routing_lists
  where nvl(routing_list_name,hr_api.g_varchar2) = nvl(p_routing_list_name,hr_api.g_varchar2);

Line: 178

  select distinct transaction_category_id
  from pqh_routing_list_members rlm, pqh_routing_categories rct
  where rlm.routing_list_id =  rct.routing_list_id
  and rct.routing_list_id = p_routing_list_id;

Line: 184

   Select name,business_group_id
     From pqh_transaction_categories_vl
    Where transaction_category_id = p_transaction_category_id;

Line: 227

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

Line: 248

End insert_validate;

Line: 253

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

Line: 274

End update_validate;

Line: 279

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

Line: 291

End delete_validate;