APPS.ONT_OEXDERUL_XMLP_PKG SQL Statements

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

Line: 18

        SELECT
          CP.USER_CONCURRENT_PROGRAM_NAME
        INTO L_REPORT_NAME
        FROM
          FND_CONCURRENT_PROGRAMS_VL CP,
          FND_CONCURRENT_REQUESTS CR
        WHERE CR.REQUEST_ID = P_CONC_REQUEST_ID
          AND CP.APPLICATION_ID = CR.PROGRAM_APPLICATION_ID
          AND CP.CONCURRENT_PROGRAM_ID = CR.CONCURRENT_PROGRAM_ID;

Line: 40

          SELECT
            NAME
          INTO OBJECT
          FROM
            OE_DEF_AK_OBJ_EXT_V
          WHERE DATABASE_OBJECT_NAME = P_OBJECT;

Line: 51

          SELECT
            DISTINCT
            ATTRIBUTE_DISPLAY_NAME
          INTO ATTRIBUTE
          FROM
            OE_DEF_AK_ATTR_EXT_V
          WHERE ATTRIBUTE_CODE = P_ATTRIBUTE;

Line: 63

          SELECT
            DISTINCT
            DISPLAY_NAME
          INTO CONDITION
          FROM
            OE_DEF_CONDITIONS_VL
          WHERE CONDITION_ID = P_CONDITION;