APPS.PQH_RNG_SHD SQL Statements

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

Line: 70

    select
		attribute_range_id,
	approver_flag,
        enable_flag,
        delete_flag,
	assignment_id,
	attribute_id,
	from_char,
	from_date,
	from_number,
	position_id,
	range_name,
	routing_category_id,
	routing_list_member_id,
	to_char,
	to_date,
	to_number,
	object_version_number
    from	pqh_attribute_ranges
    where	attribute_range_id = p_attribute_range_id;

Line: 157

    select 	attribute_range_id,
	approver_flag,
        enable_flag,
        delete_flag,
	assignment_id,
	attribute_id,
	from_char,
	from_date,
	from_number,
	position_id,
	range_name,
	routing_category_id,
	routing_list_member_id,
	to_char,
	to_date,
	to_number,
	object_version_number
    from	pqh_attribute_ranges
    where	attribute_range_id = p_attribute_range_id
    for	update nowait;

Line: 229

	p_delete_flag                 in varchar2,
	p_assignment_id                 in number,
	p_attribute_id                  in number,
	p_from_char                     in varchar2,
	p_from_date                     in date,
	p_from_number                   in number,
	p_position_id                   in number,
	p_range_name                    in varchar2,
	p_routing_category_id           in number,
	p_routing_list_member_id        in number,
	p_to_char                       in varchar2,
	p_to_date                       in date,
	p_to_number                     in number,
	p_object_version_number         in number
	)
	Return g_rec_type is
--
  l_rec	  g_rec_type;

Line: 258

  l_rec.delete_flag                    := p_delete_flag;