1551: cursor csr_get_us_city_names
1552: is
1553: select 'Y' from dual
1554: where exists(select null
1555: from pay_us_city_names
1556: where rownum =1);
1557: --
1558: -- Fix for bug 3355231 ends here.
1559: --
1559: --
1560: begin
1561: hr_utility.set_location('Entering:'|| l_proc, 1);
1562: --
1563: -- Check if any rows exist in the pay_us_city_names
1564: --
1565: open csr_get_us_city_names;
1566: fetch csr_get_us_city_names into l_exists;
1567: if csr_get_us_city_names%FOUND then