APPS.IGC_IGCCLDER_XMLP_PKG SQL Statements

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

Line: 30

    SELECT
      NAME
    INTO ORG_NAME
    FROM
      HR_OPERATING_UNITS
    WHERE ORGANIZATION_ID = P_ORG_ID;

Line: 52

      SELECT
        count(*)
      FROM
        IGC_CC_INTERFACE_ERRORS IGE
      WHERE IGE.BATCH_ID = P_BATCH_ID;

Line: 58

      SELECT
        MEANING
      FROM
        FND_LOOKUPS FND
      WHERE LOOKUP_TYPE = 'IGC_BATCH_STATUS'
        AND LOOKUP_CODE = P_LOOKUP_CODE;

Line: 97

    SELECT
      COUNT(INTERFACE_HEADER_ID)
    INTO L_HEADERS
    FROM
      IGC_CC_HEADERS_INTERFACE
    WHERE BATCH_ID = P_BATCH_ID;

Line: 112

    SELECT
      count(distinct INTERFACE_HEADER_ID)
    INTO L_ERRORS
    FROM
      IGC_CC_INTERFACE_ERRORS
    WHERE BATCH_ID = P_BATCH_ID;