564: HL.ADDRESS4 ladv_addr_line_4,
565: HL.CITY ladv_city
566: FROM
567: HZ_LOCATIONS HL,
568: IGS_AD_LOCVENUE_ADDR LA
569: WHERE
570: HL.LOCATION_ID = LA.LOCATION_ID
571: AND LA.SOURCE_TYPE = 'L'
572: AND LA.LOCATION_VENUE_CD = cp_location_cd
586: HL.ADDRESS4 ladv_addr_line_4,
587: HL.CITY ladv_city
588: FROM
589: HZ_LOCATIONS HL,
590: IGS_AD_LOCVENUE_ADDR LA ,
591: IGS_PE_LOCVENUE_USE PLU
592: WHERE
593: HL.LOCATION_ID = LA.LOCATION_ID
594: AND LA.LOCATION_VENUE_ADDR_ID = PLU.LOC_VENUE_ADDR_ID