APPS.ARP_TMP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 22

  SELECT 'A'  FROM hz_locations WHERE location_id = p_location_id;

Line: 25

  SELECT location_id  FROM hz_locations
   WHERE country                  = p_country
     AND NVL(p_ADDRESS1,'XXX')    = NVL(address1,'XXX')
     AND NVL(p_CITY    ,'XXX')    = NVL(city,'XXX')
     AND NVL(p_POSTAL_CODE,'XXX') = NVL(postal_code,'XXX')
     AND NVL(p_STATE,'XXX')       = NVL(state,'XXX')
     AND NVL(p_PROVINCE,'XXX')    = NVL(province,'XXX')
     AND NVL(p_COUNTY,'XXX')      = NVL(county,'XXX');