APPS.HXT_HXT957A_XMLP_PKG SQL Statements

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

Line: 8

  SELECT HR_ALL_ORGANIZATION_UNITS_TL.NAME INTO
  ORG_NAME FROM HR_ALL_ORGANIZATION_UNITS_TL WHERE
   (HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID=ORGANIZATION_ID1)
   AND HR_ALL_ORGANIZATION_UNITS_TL.language = userenv('LANG');

Line: 25

      SELECT ELTT.ELEMENT_NAME
      FROM   PAY_ELEMENT_TYPES_F ELT
            ,PAY_ELEMENT_TYPES_F_TL ELTT
            ,HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV
      WHERE  ELT.ELEMENT_TYPE_ID = P_ELEMENT_TYPE_ID
      AND elt.effective_start_date <= P_EFFECTIVE_START_DATE
      and elt.effective_end_date >= P_EFFECTIVE_END_DATE
      AND eltv.effective_start_date <= P_EFFECTIVE_START_DATE
      and eltv.effective_end_date >= P_EFFECTIVE_END_DATE
      and eltt.element_type_id = elt.element_type_id
      and eltv.element_type_id = elt.element_type_id
      and eltt.language = userenv('LANG')
      AND     HXT_EARNING_CATEGORY = 'ABS';