APPS.HXT_HXT956C_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  ELT.ELEMENT_TYPE_ID = arg_ELEMENT_TYPE_ID
      AND elt.effective_start_date <= arg_EFFECTIVE_START_DATE
      and elt.effective_end_date >= arg_EFFECTIVE_END_DATE
      AND    HXT_EARNING_CATEGORY = 'SDF'
      AND    ELT.element_type_id = eltt.element_type_id
      AND    ELTV.element_type_id = elt.element_type_id
      and    eltt.language = userenv('LANG');