APPS.ONT_OEXAUDHR_XMLP_PKG SQL Statements

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

Line: 59

        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: 76

        SELECT
          ENTITY_DISPLAY_NAME
        INTO L_ENTITY_DISPLAY_NAME
        FROM
          OE_PC_ENTITIES_V
        WHERE ENTITY_ID = P_ENTITY_ID;

Line: 90

        SELECT
          USER_NAME
        INTO L_USER_NAME
        FROM
          FND_USER
        WHERE USER_ID = P_USER_ID;

Line: 104

        SELECT
          RESPONSIBILITY_NAME
        INTO L_RESPONSIBILITY_NAME
        FROM
          FND_RESPONSIBILITY_TL
        WHERE RESPONSIBILITY_ID = P_RESP_ID
          AND LANGUAGE = USERENV('LANG');

Line: 119

        SELECT
          ATTRIBUTE_DISPLAY_NAME
        INTO L_ATTRIBUTE_DISPLAY_NAME
        FROM
          OE_PC_ATTRIBUTES_V
        WHERE ATTRIBUTE_ID = P_ATTRIBUTE_ID;

Line: 133

        SELECT
          SOB.NAME
        INTO L_SOB_NAME
        FROM
          GL_SETS_OF_BOOKS SOB
        WHERE SOB.SET_OF_BOOKS_ID = P_SOB_ID;

Line: 161

        SELECT
          LINE_NUMBER,
          SHIPMENT_NUMBER,
          OPTION_NUMBER,
          COMPONENT_NUMBER,
          SERVICE_NUMBER
        INTO T_LINE_NO,T_SHIP_NO,T_OPTION_NO,T_COMPONENT_NO,T_SERVICE_NO
        FROM
          OE_ORDER_LINES_ALL
        WHERE LINE_ID = LINEID1;

Line: 177

        SELECT
          LINE_NUMBER,
          SHIPMENT_NUMBER,
          OPTION_NUMBER,
          COMPONENT_NUMBER,
          SERVICE_NUMBER
        INTO T_LINE_NO,T_SHIP_NO,T_OPTION_NO,T_COMPONENT_NO,T_SERVICE_NO
        FROM
          OE_ORDER_LINES_ALL
        WHERE LINE_ID = (
          SELECT
            DISTINCT
            LINE_ID
          FROM
            OE_SALES_CREDITS
          WHERE SALES_CREDIT_ID = LINEID1 );

Line: 199

        SELECT
          LINE_NUMBER,
          SHIPMENT_NUMBER,
          OPTION_NUMBER,
          COMPONENT_NUMBER,
          SERVICE_NUMBER
        INTO T_LINE_NO,T_SHIP_NO,T_OPTION_NO,T_COMPONENT_NO,T_SERVICE_NO
        FROM
          OE_ORDER_LINES_ALL
        WHERE LINE_ID = (
          SELECT
            DISTINCT
            LINE_ID
          FROM
            OE_PRICE_ADJUSTMENTS
          WHERE PRICE_ADJUSTMENT_ID = LINEID1 );