APPS.HXT_HXT956A_XMLP_PKG SQL Statements

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

Line: 8

  select name
  into pep_name
  from  hxt_prem_eligblty_policies
  where id = pep_id;

Line: 22

  select name
  into pip_name
  from  hxt_prem_interact_policies
  where id = pip_id;

Line: 36

  select name
  into egt_type
  from  hxt_earn_group_types
  where id = egt_id;

Line: 52

      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    ELTT.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID
      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 eltt.language = userenv('LANG')
      AND     HXT_EARNING_CATEGORY IN ('OVT', 'REG');