APPS.PQH_RLM_BUS SQL Statements

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

Line: 110

    select null
    from   pqh_routing_lists a
    where  a.routing_list_id = p_routing_list_id;

Line: 189

    select null
    from   pqh_roles a
    where  a.role_id = p_role_id;

Line: 194

    select null
    from pqh_role_users_v
    where user_id = nvl(p_user_id, -1)
    and role_id = p_role_id;

Line: 300

    select null
    from   pqh_routing_list_members a
    where  a.routing_list_id=p_routing_list_id
	   and a.role_id = p_role_id
	   and nvl(a.user_id,-1) = nvl(p_user_id, -1);

Line: 382

    select null
    from   pqh_routing_list_members a
    where  a.routing_list_id=p_routing_list_id
	   and a.seq_no = p_seq_no;

Line: 539

  select enable_flag
  from pqh_routing_lists
  where routing_list_id = p_routing_list_id;

Line: 544

  select enable_flag
  from pqh_roles
  where role_id = p_role_id;

Line: 549

  select 'x'
  from pqh_role_users_v
  where role_id = p_role_id
  and user_id = p_user_id;

Line: 657

  select distinct ptc.transaction_category_id, ptc.name transaction_category_name,
  ptc.business_group_id
  from pqh_routing_list_members rlm, pqh_routing_categories rct,
       pqh_transaction_categories ptc
  where rlm.routing_list_id =  rct.routing_list_id
  and rct.routing_list_id = p_routing_list_id
  and rct.transaction_category_id = ptc.transaction_category_id;

Line: 697

select freeze_status_cd
from pqh_transaction_categories_vl
where transaction_category_id = p_transaction_category_id;

Line: 716

select distinct rtc.transaction_category_id
from pqh_attribute_ranges arg, pqh_routing_categories rtc
where routing_list_member_id = p_routing_list_member_id
and arg.routing_category_id = rtc.routing_category_id;

Line: 740

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

Line: 795

End insert_validate;

Line: 800

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

Line: 856

End update_validate;

Line: 861

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

Line: 875

End delete_validate;