18:
19:
20: cursor csr_locality_valid is
21: select 'x'
22: from pay_user_column_instances_f pucif,
23: pay_user_columns puc,
24: pay_user_tables put,
25: pay_user_rows_f purf
26: where pucif.VALUE = p_address_line_2
32: and pucif.user_row_id = purf.user_row_id
33: and purf.row_low_range_or_name in (
34: select purf1.ROW_LOW_RANGE_OR_NAME
35: from pay_user_rows_f purf1,
36: pay_user_column_instances_f pucif1,
37: pay_user_columns puc1,
38: pay_user_column_instances_f pucif2,
39: pay_user_columns puc2,
40: pay_user_rows_f purf2
34: select purf1.ROW_LOW_RANGE_OR_NAME
35: from pay_user_rows_f purf1,
36: pay_user_column_instances_f pucif1,
37: pay_user_columns puc1,
38: pay_user_column_instances_f pucif2,
39: pay_user_columns puc2,
40: pay_user_rows_f purf2
41: where puc1.user_column_name = 'COUNTY CODE'
42: and puc1.user_table_id = put.user_table_id