2721: SELECT 'Y'
2722: INTO lv_update_prr
2723: FROM dual
2724: WHERE EXISTS (SELECT 0
2725: FROM pay_us_city_tax_info_f
2726: WHERE jurisdiction_code = main_old_juri_code)
2727: OR EXISTS (SELECT 0
2728: FROM pay_us_city_tax_info_f
2729: WHERE jurisdiction_code = main_new_juri_code)
2724: WHERE EXISTS (SELECT 0
2725: FROM pay_us_city_tax_info_f
2726: WHERE jurisdiction_code = main_old_juri_code)
2727: OR EXISTS (SELECT 0
2728: FROM pay_us_city_tax_info_f
2729: WHERE jurisdiction_code = main_new_juri_code)
2730: OR length(main_old_juri_code) = 2 ;
2731: EXCEPTION
2732: WHEN NO_DATA_FOUND THEN