APPS.ZX_ZXJGTAX_XMLP_PKG SQL Statements

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

Line: 11

    SELECT
      'ZXARRECV'
    INTO DUMMY
    FROM
      DUAL;

Line: 29

    SELECT
      COUNT(1)
    INTO CP_TRL_ROW_COUNT
    FROM
      ZX_REP_CONTEXT_T CON,
      ZX_REP_TRX_DETAIL_T DET
    WHERE CON.REQUEST_ID = P_CONC_REQUEST_ID
      AND DET.REQUEST_ID = CON.REQUEST_ID
      AND NVL(DET.REP_CONTEXT_ID
       ,CON.REP_CONTEXT_ID) = CON.REP_CONTEXT_ID;

Line: 167

      SELECT
        SUM(A.TAXABLE_AMT)
      INTO L_INV_TAXABLE_AMT
      FROM
        ZX_REP_TRX_DETAIL_T A
      WHERE A.TRX_ID = C_TRX_ID
        AND A.TRX_LINE_ID = C_TRX_LINE_ID
        AND A.REQUEST_ID = P_CONC_REQUEST_ID
        AND A.ROWID = (
        SELECT
          MIN(B.ROWID)
        FROM
          ZX_REP_TRX_DETAIL_T B
        WHERE A.TRX_ID = B.TRX_ID
          AND A.TRX_LINE_ID = B.TRX_LINE_ID
          AND B.REQUEST_ID = P_CONC_REQUEST_ID );

Line: 209

      SELECT
        SUM(A.TAXABLE_AMT_FUNCL_CURR)
      INTO L_INV_TAXABLE_AMT
      FROM
        ZX_REP_TRX_DETAIL_T A
      WHERE A.TRX_ID = C_TRX_ID
        AND A.TRX_LINE_ID = C_TRX_LINE_ID
        AND A.REQUEST_ID = P_CONC_REQUEST_ID
        AND A.ROWID = (
        SELECT
          MIN(B.ROWID)
        FROM
          ZX_REP_TRX_DETAIL_T B
        WHERE A.TRX_ID = B.TRX_ID
          AND A.TRX_LINE_ID = B.TRX_LINE_ID
          AND B.REQUEST_ID = P_CONC_REQUEST_ID );