APPS.HXT_HXT956E_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 ELT1
            ,PAY_ELEMENT_TYPES_F_TL ELTT
            ,HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV1
      WHERE  ELTV1.ELEMENT_TYPE_ID = P_ELT_PRIOR_PREM_ID
      AND    ELTV1.EFFECTIVE_START_DATE <= P_EFFECTIVE_START_DATE
      AND    ELTV1.EFFECTIVE_END_DATE >= P_EFFECTIVE_END_DATE
      AND    ELTV1.ELEMENT_TYPE_ID = ELT1.ELEMENT_TYPE_ID
      AND    ELT1.EFFECTIVE_START_DATE <= P_EFFECTIVE_START_DATE
      AND    ELT1.EFFECTIVE_END_DATE >= P_EFFECTIVE_END_DATE
      AND    ELT1.element_type_id = eltt.element_type_id
      AND    ELTV1.element_type_id = elt1.element_type_id
      and    eltt.language = userenv('LANG')
      and (eltv1.hxt_premium_type = 'FACTOR'
      AND eltv1.hxt_earning_category = 'OVT'
       or eltv1.hxt_earning_category NOT IN ('REG', 'OVT', 'ABS'));

Line: 80

      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 = P_ELT_EARNED_PREM_ID
      AND    ELTV.EFFECTIVE_START_DATE <= P_EFFECTIVE_START_DATE
      AND    ELTV.EFFECTIVE_END_DATE >= P_EFFECTIVE_END_DATE
      AND    ELTV.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID
      AND    ELT.EFFECTIVE_START_DATE <= P_EFFECTIVE_START_DATE
      AND    ELT.EFFECTIVE_END_DATE >= P_EFFECTIVE_END_DATE
      AND    ELT.element_type_id = eltt.element_type_id
      AND    ELTV.element_type_id = elt.element_type_id
      and    eltt.language = userenv('LANG')
      and (eltv.hxt_premium_type = 'FACTOR'
      AND eltv.hxt_earning_category = 'OVT'
       or eltv.hxt_earning_category NOT IN ('REG', 'OVT', 'ABS'));