APPS.OKS_OKSSCOFM_XMLP_PKG SQL Statements

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

Line: 34

    SELECT
      NAME
    INTO P_SALESREP_NAME
    FROM
      JTF_RS_SALESREPS
    WHERE SALESREP_ID = SR_SALESREP_ID
      AND ORG_ID = CF_SALESREP_NAMEFORMULA.ORG_ID
      AND ROWNUM < 2;

Line: 47

    SELECT
      PARTY_NAME
    INTO P_PARTY_NAME
    FROM
      HZ_PARTIES
    WHERE PARTY_ID = HZ_PARTY_ID
      AND ROWNUM = 1;

Line: 58

      SELECT
        NVL(SUM(PRICE_NEGOTIATED)
           ,0)
      FROM
        OKC_K_LINES_B
      WHERE DNZ_CHR_ID = CONTRACT_ID
        AND LSE_ID in ( 25 , 7 , 9 , 10 , 8 , 35 , 11 )
        AND DATE_CANCELLED is NULL
        AND PRICE_NEGOTIATED between 0
        AND 90999999
      HAVING NVL(SUM(PRICE_NEGOTIATED)
         ,0) >= NVL(P_MINIMUM_CONTRACT_VALUE
         ,NVL(SUM(PRICE_NEGOTIATED)
            ,0))
        AND NVL(SUM(PRICE_NEGOTIATED)
         ,0) <= NVL(P_MAXIMUM_CONTRACT_VALUE
         ,NVL(SUM(PRICE_NEGOTIATED)
            ,0));

Line: 101

      SELECT
        NVL(SUM((KL.PRICE_NEGOTIATED / CEIL(DECODE(SIGN(END_DATE - START_DATE)
                           ,0
                           ,1
                           ,(MONTHS_BETWEEN(KL.END_DATE
                                         ,KL.START_DATE))))) * CEIL(DECODE(SIGN(P_REGZ_DATE - KL.START_DATE)
                           ,0
                           ,1
                           ,MONTHS_BETWEEN(P_REGZ_DATE
                                         ,KL.START_DATE))))
           ,0)
      FROM
        OKC_K_LINES_B KL
      WHERE KL.DNZ_CHR_ID = CONTRACT_ID
        AND KL.LSE_ID in ( 25 , 7 , 9 , 10 , 8 , 35 , 11 )
        AND KL.PRICE_NEGOTIATED between 0
        AND 90999999
        AND KL.START_DATE <= P_REGZ_DATE
      HAVING NVL(SUM(PRICE_NEGOTIATED)
         ,0) >= NVL(P_MINIMUM_CONTRACT_VALUE
         ,NVL(SUM(PRICE_NEGOTIATED)
            ,0))
        AND NVL(SUM(PRICE_NEGOTIATED)
         ,0) <= NVL(P_MAXIMUM_CONTRACT_VALUE
         ,NVL(SUM(PRICE_NEGOTIATED)
            ,0));

Line: 145

      SELECT
        NAME
      FROM
        JTF_RS_SALESREPS
      WHERE SALESREP_ID = CN_SALESREPID;

Line: 151

      SELECT
        NAME
      FROM
        HR_OPERATING_UNITS
      WHERE ORGANIZATION_ID = CN_ORG_ID;

Line: 157

      SELECT
        NAME
      FROM
        OKC_K_GROUPS_V
      WHERE ID = CN_CONTRACT_GROUP_ID;

Line: 200

      P_CONTRACT_GROUP_WHERE := ' and kh.id in ( select INCLUDED_CHR_ID from okc_k_grpings
                                                                                    start with CGP_PARENT_ID =  :p_contract_group
                                                                                    connect by CGP_PARENT_ID = PRIOR INCLUDED_CGP_ID ) ';