APPS.PAY_PAYGBACT_XMLP_PKG SQL Statements

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

Line: 42

      SELECT
        BDEF.DEFINED_BALANCE_ID
      INTO DEF_BAL_ID
      FROM
        PAY_DEFINED_BALANCES BDEF,
        PAY_BALANCE_TYPES BTYP,
        PAY_BALANCE_DIMENSIONS BDIM
      WHERE BDEF.BALANCE_TYPE_ID = BTYP.BALANCE_TYPE_ID
        AND ( ( BTYP.BALANCE_NAME = ELEMENT_NAME || DECODE(INPUT_NAME
            ,'Pay Value'
            ,' Employee'
            ,'NI Employer'
            ,' Employer'
            ,'NI Able'
            ,' Able'
            ,'NI CO Able'
            ,' CO Able'
            ,'NI CO Employee'
            ,' CO'
            ,'')
        AND BDIM.DIMENSION_NAME = '_PER_NI_PTD' )
      OR ( BTYP.BALANCE_NAME = ELEMENT_NAME
        AND BDIM.DIMENSION_NAME = '_PER_NI_PTD' )
      OR ( BTYP.BALANCE_NAME = ELEMENT_NAME
        AND NVL(INPUT_NAME
         ,'Pay Value') = 'Pay Value'
        AND BDIM.DIMENSION_NAME = '_PER_PAYE_PTD' ) )
        AND BDEF.BALANCE_DIMENSION_ID = BDIM.BALANCE_DIMENSION_ID;

Line: 96

      SELECT
        BDEF.DEFINED_BALANCE_ID
      INTO DEF_BAL_ID
      FROM
        PAY_DEFINED_BALANCES BDEF,
        PAY_BALANCE_TYPES BTYP,
        PAY_BALANCE_DIMENSIONS BDIM
      WHERE BDEF.BALANCE_TYPE_ID = BTYP.BALANCE_TYPE_ID
        AND ( ( BTYP.BALANCE_NAME = ELEMENT_NAME || DECODE(INPUT_NAME
            ,'Pay Value'
            ,' Employee'
            ,'NI Employer'
            ,' Employer'
            ,'NI Able'
            ,' Able'
            ,'NI CO Able'
            ,' CO Able'
            ,'NI CO Employee'
            ,' CO'
            ,'x') )
      OR ( BTYP.BALANCE_NAME = ELEMENT_NAME
        AND NVL(INPUT_NAME
         ,'Pay Value') = 'Pay Value' ) )
        AND BDEF.BALANCE_DIMENSION_ID = BDIM.BALANCE_DIMENSION_ID
        AND BDIM.DIMENSION_NAME = '_PER_TD_YTD';