APPS.HXT_HXT956D_XMLP_PKG SQL Statements

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

Line: 10

      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  ELTV.ELEMENT_TYPE_ID = ELT_BASE_ID
      AND    ELTV.EFFECTIVE_START_DATE <= arg_effective_start_date
      AND    ELTV.EFFECTIVE_END_DATE >= arg_effective_end_date
      AND    ELTV.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID
      AND    ELT.EFFECTIVE_START_DATE <= arg_effective_start_date
      AND    ELT.EFFECTIVE_END_DATE >= arg_effective_end_date
      AND    ELT.element_type_id = eltv.element_type_id
      AND    ELTT.element_type_id = elt.element_type_id
      AND    ELTT.language = userenv('LANG')
      AND    ELTV.HXT_EARNING_CATEGORY IN ('REG', 'OVT', 'ABS');

Line: 50

      SELECT ELTT.ELEMENT_NAME
      FROM   PAY_ELEMENT_TYPES_F ELT1
            ,pay_element_types_f_tl eltt
      WHERE  ELT1.ELEMENT_TYPE_ID = ELT_PREMIUM_ID
      AND    ELT1.element_type_id = eltt.element_type_id
      AND    eltt.language  = userenv('LANG');