APPS.PAY_PAYRPFAR_XMLP_PKG SQL Statements

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

Line: 7

    INSERT INTO FND_SESSIONS
      (SESSION_ID
      ,EFFECTIVE_DATE)
      SELECT
        USERENV('sessionid'),
        TRUNC(SYSDATE)
      FROM
        SYS.DUAL
      WHERE not exists (
        SELECT
          1
        FROM
          FND_SESSIONS FS
        WHERE FS.SESSION_ID = USERENV('sessionid') );

Line: 22

      SELECT
        PARAMETER_VALUE
      INTO
        L_TRACE_VALUE
      FROM
        PAY_ACTION_PARAMETERS
      WHERE PARAMETER_NAME = 'TRACE';

Line: 57

      SELECT
        MEANING
      INTO
        V_MEANING
      FROM
        HR_LOOKUPS
      WHERE LOOKUP_TYPE = 'TRIGGER_STATUS'
        AND LOOKUP_CODE = P_STATUS;

Line: 75

      SELECT
        MEANING
      INTO
        V_MEANING
      FROM
        HR_LOOKUPS
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = P_ENABLED_FLAG;