APPS.ASP_SVCCONT_CONTENT_PROVIDER SQL Statements

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

Line: 74

      SELECT HZP.party_id customer_id
            ,HZP.party_name customer_name
            ,CHRB.contract_number || DECODE(CHRB.contract_number_modifier, NULL,NULL,'-'|| CHRB.contract_number_modifier) contract_number
            ,CHRB.END_DATE expiration_date
      FROM  okc_k_headers_all_b CHRB
           ,oks_k_headers_b KHRB
           ,okc_subclasses_v SCSV
           ,okc_k_party_roles_b CPL
           ,hz_parties HZP
      WHERE CHRB.id = c_contract_header_id --
      AND   CHRB.id = CPL.dnz_chr_id
      AND   SCSV.code = CHRB.scs_code
      AND   SCSV.cls_code = 'SERVICE'
      AND   CHRB.id = KHRB.chr_id
      AND   CPL.cle_id IS NULL
      AND   CPL.rle_code in('CUSTOMER','SUBSCRIBER')
      AND   CPL.jtot_object1_code = 'OKX_PARTY'
      AND   CPL.object1_id1 = HZP.party_id
      and rownum < 2;