APPS.OKL_INSURANCE_WF SQL Statements

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

Line: 99

      SELECT STE_CODE
      FROM  OKC_K_HEADERS_V KHR , OKC_STATUSES_B OST
      WHERE  KHR.ID =  p_khr_id
      AND KHR.STS_CODE = OST.CODE;

Line: 106

      SELECT 'x'
      FROM  OKL_INS_POLICIES_B IPYB
      WHERE IPYB.IPY_TYPE <> 'OPTIONAL_POLICY' AND
            SYSDATE BETWEEN IPYB.DATE_FROM AND IPYB.DATE_TO
        AND IPYB.KHR_ID = p_khr_id ;

Line: 220

      SELECT hze.party_site_id address,
             hdr.cust_acct_id acctid,
             rle.OBJECT1_ID1 partyid
      FROM   okc_k_headers_b hdr,
             okc_k_party_roles_b rle,
             hz_cust_acct_sites_all hze,
             hz_cust_site_uses_all hz
      WHERE  rle.rle_code = 'LESSEE'
      and    rle.dnz_chr_id =  hdr.id
      and    hdr.bill_to_site_use_id = hz.SITE_USE_ID
      and    hze.cust_acct_site_id = hz.cust_acct_site_id
      and    hdr.id = contract_id;

Line: 234

      SELECT CONTRACT_NUMBER
            ,ORG_ID
      FROM OKC_K_HEADERS_ALL_B
      WHERE ID  = p_contract_id ;

Line: 243

      SELECT TASK_TEMPLATE_GROUP_ID,
             OWNER_TYPE_CODE,
             OWNER_ID
      FROM OKL_SYSTEM_PARAMS_ALL
      WHERE ORG_ID = p_org_id;

Line: 254

      SELECT T.TEMPLATE_GROUP_NAME
      FROM JTF_TASK_TEMP_GROUPS_VL T,
           JTF_OBJECTS_VL OB
      WHERE T.SOURCE_OBJECT_TYPE_CODE = OB.OBJECT_CODE
      AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(T.START_DATE_ACTIVE, SYSDATE))
      AND TRUNC(NVL(T.END_DATE_ACTIVE, SYSDATE))
      AND T.TASK_TEMPLATE_GROUP_ID = temp_grp_id;