APPS.OTA_OTAFRBCR_XMLP_PKG SQL Statements

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

Line: 9

      SELECT
        EFFECTIVE_DATE
      INTO
        C_SESSION_DATE
      FROM
        FND_SESSIONS
      WHERE SESSION_ID = USERENV('SESSIONID');

Line: 18

        INSERT INTO FND_SESSIONS
          (SESSION_ID
          ,EFFECTIVE_DATE)
        VALUES   (USERENV('SESSIONID')
          ,SYSDATE);

Line: 28

    SELECT
      NAME
    INTO
      C_TRAINING_PLAN_NAME
    FROM
      OTA_TRAINING_PLANS OTP
    WHERE OTP.TRAINING_PLAN_ID = P_TRAINING_PLAN_ID;

Line: 35

    SELECT
      MEANING
    INTO
      C_ROLLUP_LEVEL
    FROM
      FND_COMMON_LOOKUPS
    WHERE LOOKUP_TYPE = 'TP_REPORT_LEVEL'
      AND APPLICATION_ID = 800
      AND LOOKUP_CODE = P_ROLLUP;