APPS.PON_PONXFEDOPPS_XMLP_PKG SQL Statements

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

Line: 60

      select hrall.location_code
      into issue_office_desc
      FROM hr_locations_all hrall, hr_location_extra_info loceit
      WHERE loceit.location_id = hrall.location_id
       and loceit.information_type = 'CLM_OFFICE_CODE'
       and po_uda_data_util.is_location_valid(hrall.location_id, 'ISSUING_OFFICE') = 'Y'
       and hrall.location_id = p_issue_office;