APPS.ONT_OEXCEXP_XMLP_PKG SQL Statements

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

Line: 6

      SELECT
        NAME
      INTO CP_CHECK_RULE
      FROM
        OE_CREDIT_CHECK_RULES
      WHERE CREDIT_CHECK_RULE_ID = P_CR_CHECK_RULE_ID;

Line: 36

      SELECT
        SOB.NAME
      INTO L_SOB_NAME
      FROM
        GL_SETS_OF_BOOKS SOB
      WHERE SOB.SET_OF_BOOKS_ID = OE_SYS_PARAMETERS.VALUE('SET_OF_BOOKS_ID'
                             ,MO_GLOBAL.GET_CURRENT_ORG_ID);

Line: 88

    SELECT
      NAME
    INTO CP_OPERATING_UNIT
    FROM
      HR_OPERATING_UNITS
    WHERE ORGANIZATION_ID = P_ORG_ID;

Line: 133

    SELECT
      SUM(BASE_CUR_OVERALL_LIMIT)
    INTO CP_CUST_LIMIT_GRAND_TOTAL
    FROM
      OE_CREDIT_EXPOSURE_TEMP
    WHERE CUSTOMER_ID = D_CUSTOMER_ID
      AND BILL_TO_SITE_ID IS NOT NULL;

Line: 147

    SELECT
      SUM(BASE_CUR_EXPOSURE)
    INTO L_EXPOSURE
    FROM
      OE_CREDIT_EXPOSURE_TEMP
    WHERE CUSTOMER_ID = D_CUSTOMER_ID
      AND BILL_TO_SITE_ID IS NOT NULL;

Line: 154

    SELECT
      SUM(UNCHECKED_EXPOSURE)
    INTO L_UNCHECKED_EXPOSURE
    FROM
      OE_CREDIT_EXPOSURE_TEMP
    WHERE CUSTOMER_ID = D_CUSTOMER_ID
      AND BILL_TO_SITE_ID IS NOT NULL;

Line: 167

    SELECT
      SUM(BASE_CUR_AVAILABLE)
    INTO CP_CUST_AVAILABLE_GRAND_TOTAL
    FROM
      OE_CREDIT_EXPOSURE_TEMP
    WHERE CUSTOMER_ID = D_CUSTOMER_ID
      AND BILL_TO_SITE_ID IS NOT NULL;

Line: 216

    SELECT
      MEANING
    INTO CP_REPORT_OPTION
    FROM
      OE_LOOKUPS
    WHERE LOOKUP_TYPE = 'ONT_CC_EXC_REPORTBY_OPTION'
      AND ENABLED_FLAG = 'Y'
      AND LOOKUP_CODE = P_REPORT_BY_OPTION;

Line: 277

      SELECT
        DISTINCT
        PARTY_NAME
      INTO CP_PARTY_NAME
      FROM
        HZ_PARTIES
      WHERE PARTY_ID = P_SPECIFIC_PARTY_ID;

Line: 285

      SELECT
        DISTINCT
        PARTY_NUMBER
      INTO CP_PARTY_NUMBER
      FROM
        HZ_PARTIES
      WHERE PARTY_ID = P_SPEC_PARTY_NUM_ID;

Line: 303

      SELECT
        PARTY_ID
      FROM
        OE_CREDIT_HIERARCHY_TEMP;

Line: 310

    SELECT
      A.PARENT_ID
    INTO L_TOP_PARENT
    FROM
      HZ_HIERARCHY_NODES A
    WHERE A.TOP_PARENT_FLAG = 'Y'
      AND A.HIERARCHY_TYPE = L_REL_TYPE
      AND A.CHILD_ID IN (
      SELECT
        B.PARENT_ID
      FROM
        HZ_HIERARCHY_NODES B
      WHERE B.HIERARCHY_TYPE = L_REL_TYPE
        AND B.CHILD_ID = NVL(P_SPECIFIC_PARTY_ID
         ,P_SPEC_PARTY_NUM_ID) );

Line: 325

    INSERT INTO OE_CREDIT_HIERARCHY_TEMP
      (PARTY_ID
      ,PARTY_PARENT_ID
      ,PARTY_NAME
      ,PARTY_NUMBER
      ,PARTY_LEVEL)
      SELECT
        PARTY_ID,
        NULL,
        P.PARTY_NAME,
        P.PARTY_NUMBER,
        0
      FROM
        HZ_PARTIES P
      WHERE P.PARTY_ID = L_TOP_PARENT;

Line: 340

    INSERT INTO OE_CREDIT_HIERARCHY_TEMP
      (PARTY_ID
      ,PARTY_PARENT_ID
      ,PARTY_LEVEL)
      SELECT
        OBJECT_ID,
        SUBJECT_ID,
        LEVEL
      FROM
        HZ_RELATIONSHIPS
      WHERE RELATIONSHIP_TYPE = L_REL_TYPE
      START WITH SUBJECT_ID = L_TOP_PARENT
      CONNECT BY PRIOR OBJECT_ID = SUBJECT_ID
        AND DIRECTION_CODE = 'P';

Line: 355

      SELECT
        PARTY_NAME,
        PARTY_NUMBER
      INTO L_PARTY_NAME,L_PARTY_NUMBER
      FROM
        HZ_PARTIES
      WHERE PARTY_ID = HIER_CSR_REC.PARTY_ID;

Line: 362

      UPDATE
        OE_CREDIT_HIERARCHY_TEMP
      SET
        PARTY_NAME = L_PARTY_NAME
        ,PARTY_NUMBER = L_PARTY_NUMBER
      WHERE PARTY_ID = HIER_CSR_REC.PARTY_ID;

Line: 592

    SELECT COUNT(1)
    INTO L_COUNT
    FROM HZ_RELATIONSHIPS
    WHERE RELATIONSHIP_TYPE=L_PROFILE
      AND (SUBJECT_ID=P_SPECIFIC_PARTY_ID
          OR OBJECT_ID=P_SPECIFIC_PARTY_ID);

Line: 601

    SELECT COUNT(1)
    INTO L_COUNT
    FROM HZ_RELATIONSHIPS
    WHERE RELATIONSHIP_TYPE=L_PROFILE
      AND (SUBJECT_ID=P_SPEC_PARTY_NUM_ID
        OR OBJECT_ID=P_SPEC_PARTY_NUM_ID);

Line: 624

  SELECT COUNT(1)
  INTO L_COUNT
  FROM OE_CREDIT_HIERARCHY_TEMP;

Line: 643

  SELECT COUNT(1)
  INTO L_COUNT
  FROM OE_CREDIT_EXPOSURE_TEMP
  WHERE PARTY_ID IS NOT NULL
  AND CUSTOMER_ID IS NOT NULL
  AND REPORT_BY_OPTION='PARTY_DETAILS';