APPS.HR_RO_LOCATION_VAL SQL Statements

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

Line: 13

				select 'x'
				from  hr_lookups
				where lookup_type = 'RO_PER_COUNTIES'
				and   meaning     = p_address_line_1
				and   enabled_flag  ='Y';

Line: 21

				select 'x'
					from   pay_user_column_instances_f pucif,
				         pay_user_columns puc,
				         pay_user_tables put,
				         pay_user_rows_f purf
					where  pucif.VALUE          = p_address_line_2
				  and    puc.user_column_name = 'LOCALITY'
					and    puc.user_table_id    = put.user_table_id
					and    pucif.user_column_id = puc.user_column_id
					and    put.user_table_name  = 'RO_LOCALITY_DETAILS'
					and    purf.user_table_id   = put.user_table_id
					and    pucif.user_row_id    = purf.user_row_id
					and    purf.row_low_range_or_name in (
									select purf1.ROW_LOW_RANGE_OR_NAME
									from   pay_user_rows_f purf1,
										     pay_user_column_instances_f pucif1,
										     pay_user_columns puc1,
										     pay_user_column_instances_f pucif2,
										     pay_user_columns puc2,
										     pay_user_rows_f purf2
									where  puc1.user_column_name = 'COUNTY CODE'
									and    puc1.user_table_id = put.user_table_id
									and    pucif1.user_column_id = puc1.user_column_id
									and    pucif1.value = (select lookup_code
														             from   hr_lookups
												                 where  lookup_type = 'RO_PER_COUNTIES'
												                 and    enabled_flag='Y'
																		     and    meaning =  p_address_line_1)
									and    pucif1.user_row_id    = purf1.user_row_id
									and    purf1.user_table_id   = put.user_table_id
									and    purf1.row_low_range_or_name = purf2.row_low_range_or_name
									and    purf2.user_table_id   = put.user_table_id
									and    puc2.user_column_name = 'LEVEL'
									and    puc2.user_table_id = put.user_table_id
									and    pucif2.user_column_id = puc2.user_column_id
									and    pucif2.value = '3'
									and    purf2.user_row_id = pucif2.user_row_id);

Line: 136

   select 'x'
   from   hr_locations_all
   where  location_code  = p_location_code;

Line: 175

PROCEDURE UPDATE_RO_LOCATION( p_address_line_1  IN  VARCHAR2  DEFAULT NULL
,p_address_line_2                 IN  VARCHAR2  DEFAULT NULL
,p_country                        IN  VARCHAR2  DEFAULT NULL
,p_postal_code                    IN  VARCHAR2  DEFAULT NULL
,p_style                          IN  VARCHAR2  DEFAULT NULL
) IS

l_proc varchar2(60);

Line: 185

l_proc:= g_package||'UPDATE_RO_LOCATION';

Line: 202

END UPDATE_RO_LOCATION;