APPS.ARP_ALOC_PKG SQL Statements

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

Line: 36

select 	distinct location_segment_user_value
from	ar_location_values
where	location_segment_qualifier = p_segment_qualifier
and	location_segment_value	   = upper(p_segment_value);

Line: 85

	select 1
	into   dummy
	from 	ar_location_values
	where	location_segment_id 		= p_segment_id
	and	location_segment_user_value	= p_segment_user_value;

Line: 131

	select 	from_postal_code,
		to_postal_code
	into	l_from_postal_code,
		l_to_postal_code
	from	ar_postal_code_ranges_v
	where	location_segment_id	= p_segment_id;

Line: 180

	select 	parent_id,
		parent_user_value
	into 	p_parent_segment_id,
		p_parent_segment_user_val
	from 	ar_loc_two_level_v
	where	child_id	= p_child_segment_id;