APPS.HXT_HXT957F_XMLP_PKG SQL Statements

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

Line: 29

              SELECT NAME
              FROM
              HR_ALL_ORGANIZATION_UNITS_TL
              WHERE  ORGANIZATION_ID = VAR_TYPE_ID
              AND language = userenv('LANG');

Line: 53

              SELECT LOCATION_CODE
              FROM   HR_LOCATIONS_ALL_TL
              WHERE  LOCATION_ID = VAR_TYPE_ID
              AND  LANGUAGE = USERENV('LANG');

Line: 76

              SELECT ELEMENT_NAME
              FROM   PAY_ELEMENT_TYPES_F_TL
              WHERE  ELEMENT_TYPE_ID = VAR_TYPE_ID
	      AND  LANGUAGE = USERENV('LANG');