APPS.PER_RO_ADDRESS SQL Statements

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

Line: 7

	    SELECT style,person_id
	    FROM   per_addresses
	    WHERE  address_id=p_address_id;

Line: 24

			SELECT  address_id
			FROM    per_addresses pa
			WHERE   pa.person_id = p_person_id
			AND     pa.address_type = p_address_type
			AND     (
			                pa.address_id <> p_address_id
			        OR      p_address_id IS NULL
			        )
			AND     nvl (pa.date_to, g_last_date) >= p_date_from
			AND     pa.date_from <= nvl (p_date_to, g_last_date);

Line: 83

		select 1 into l_locality_exists from dual where p_address_line2 in (
		select pucif.VALUE
		from pay_user_column_instances_f pucif, pay_user_columns puc, pay_user_tables put, pay_user_rows_f purf
		where  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_line1)
						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: 177

	PROCEDURE update_ro_address (
								p_address_id   		  IN 	NUMBER,
	                            p_address_type        IN    VARCHAR2,
	                            p_date_from           IN    DATE,
	                            p_date_to             IN    DATE,
	                            p_address_line1       IN 	VARCHAR2,
	                            p_address_line2       IN 	VARCHAR2,
		            p_address_line3       IN	VARCHAR2
							)
	IS
	    --
	    l_style        per_addresses.style%TYPE;

Line: 194

	   hr_utility.trace('RO not installed.Leaving update_ro_address');

Line: 215

	END update_ro_address;

Line: 218

	PROCEDURE update_ro_address_style(
								p_address_id		 IN 		NUMBER,
	                            p_style              IN 		VARCHAR2,
	                            p_address_type       IN		    VARCHAR2,
	                            p_date_from          IN     	DATE,
	                            p_date_to            IN     	DATE,
	                            p_address_line1      IN 		VARCHAR2,
	                            p_address_line2      IN 		VARCHAR2,
								p_address_line3       IN	VARCHAR2
															)
	IS
	    --
		l_style        per_addresses.style%TYPE;

Line: 236

	   hr_utility.trace('RO not installed.Leaving update_pl_address_style');

Line: 255

	END update_ro_address_style;