APPS.OKS_OKSCOBKS_XMLP_PKG SQL Statements

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

Line: 58

      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 :P_START_DATE_FROM and :P_START_DATE_TO
                                                                           and scs_code in ( ''SERVICE'' , ''WARRANTY'' ) )
                                                                and CGP_PARENT_ID = :p_contract_group
                                                                connect by CGP_PARENT_ID = PRIOR INCLUDED_CGP_ID ) cgrp ';