APPS.PQH_RCT_SHD SQL Statements

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

Line: 81

    select
	routing_category_id,
	transaction_category_id,
        enable_flag,
        default_flag,
        delete_flag,
	routing_list_id,
	position_structure_id,
	override_position_id,
	override_assignment_id,
	override_role_id,
        override_user_id,
	object_version_number
    from	pqh_routing_categories
    where	routing_category_id = p_routing_category_id;

Line: 163

    select 	routing_category_id,
	transaction_category_id,
        enable_flag,
        default_flag,
        delete_flag,
	routing_list_id,
	position_structure_id,
	override_position_id,
	override_assignment_id,
	override_role_id,
	override_user_id,
	object_version_number
    from	pqh_routing_categories
    where	routing_category_id = p_routing_category_id
    for	update nowait;

Line: 231

        p_delete_flag                    in varchar2,
	p_routing_list_id               in number,
	p_position_structure_id         in number,
	p_override_position_id          in number,
	p_override_assignment_id        in number,
	p_override_role_id            in number,
	p_override_user_id            in number,
	p_object_version_number         in number
	)
	Return g_rec_type is
--
  l_rec	  g_rec_type;

Line: 255

  l_rec.delete_flag                   := p_delete_flag ;