APPS.PAY_US_CITY_PKG dependencies on DUAL

Line 870: FROM dual

866: l_prov_abbrev varchar2(5);
867:
868: /*Modified query for performance enhancement Bug No. 3346024 */
869: CURSOR C1 is SELECT 'x'
870: FROM dual
871: where exists(
872: SELECT region_1,town_or_city
873: FROM per_addresses
874: WHERE region_1 = l_prov_abbrev

Line 880: FROM dual

876: AND ROWNUM < 2);
877:
878: /*Modified query for performance enhancement Bug No. 3346024 */
879: CURSOR C2 is SELECT 'x'
880: FROM dual
881: where exists(
882: SELECT region_1,region_2,town_or_city
883: -- Note that in per_addresses table town_or_city, region 2 and region 1
884: -- are refered to as