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