Line 83: select 1 into l_locality_exists from dual where p_address_line2 in (
79: --
80: if p_address_line1 is not null and p_address_line2 is not null then
81: begin
82: 83: select 1 into l_locality_exists from dual where p_address_line2 in ( 84: select pucif.VALUE
85: from pay_user_column_instances_f pucif, pay_user_columns puc, pay_user_tables put, pay_user_rows_f purf
86: where puc.user_column_name = 'LOCALITY'
87: and puc.user_table_id = put.user_table_id