eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_CITY_PKG dependencies on DUAL

Line 820: FROM dual

816: l_prov_abbrev varchar2(5);
817:
818: /*Modified query for performance enhancement Bug No. 3346024 */
819: CURSOR C1 is SELECT 'x'
820: FROM dual
821: where exists(
822: SELECT region_1,town_or_city
823: FROM per_addresses
824: WHERE region_1 = l_prov_abbrev

Line 830: FROM dual

826: AND ROWNUM < 2);
827:
828: /*Modified query for performance enhancement Bug No. 3346024 */
829: CURSOR C2 is SELECT 'x'
830: FROM dual
831: where exists(
832: SELECT region_1,region_2,town_or_city
833: -- Note that in per_addresses table town_or_city, region 2 and region 1
834: -- are refered to as