APPS.OKS_OKSSUMCO_XMLP_PKG SQL Statements

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

Line: 11

      SELECT
        NAME
      FROM
        JTF_RS_SALESREPS SREP
      WHERE SALESREP_ID = CN_SALESREP_ID
        AND ORG_ID = CN_ORG_ID;

Line: 95

      P_CONTRACT_GROUP_FROM := ' ,  ( select INCLUDED_CHR_ID
                                                                  from okc_k_grpings
                                                                  start with INCLUDED_CHR_ID IN
                                                                         ( select /*+ cardinality (b,1) */ id
                                                                           from okc_k_headers_b b
                                                                           where start_date between to_date(:lP_START_FROM_DATE,''DD-MM-YYYY'') and to_date(:lP_START_TO_DATE,''DD-MM-YYYY'')
                                                                           and scs_code in ( ''SERVICE'' , ''WARRANTY'' ) )
                                                                and CGP_PARENT_ID = :p_contract_group
                                                                connect by CGP_PARENT_ID = PRIOR INCLUDED_CGP_ID ) cgrp ';

Line: 123

      SELECT
        SUM(PRICE_NEGOTIATED)
      FROM
        OKC_K_LINES_B
      WHERE DNZ_CHR_ID = CN_CONTRACT_ID
        AND LSE_ID IN ( 7 , 8 , 9 , 10 , 11 , 35 , 13 , 18 , 25 )
        AND STS_CODE = CV_STS_CODE;

Line: 158

      SELECT
        SUM(PRICE_NEGOTIATED / (END_DATE - START_DATE + 1))
      FROM
        OKC_K_LINES_B
      WHERE DNZ_CHR_ID = CN_CONTRACT_ID
        AND LSE_ID IN ( 7 , 8 , 9 , 10 , 11 , 35 , 13 , 18 , 25 )
        AND STS_CODE = CV_STS_CODE;