APPS.OKS_QPATTRIB_PVT SQL Statements

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

Line: 16

      Select st.cust_account_id into l_customer_id
      From   hz_cust_site_uses_all  su,
             hz_cust_acct_sites_all st,
             okc_k_headers_b        kh
      Where  site_use_id = kh.BILL_TO_SITE_USE_ID     and
             su.cust_acct_site_id = st.cust_acct_site_id and
             kh.id = p_chr_id;

Line: 28

      Select distinct customer_profile_class_id bulk collect into l_acc_type_tbl
      From   ar_customer_profiles
      Where  customer_id = l_customer_id;

Line: 57

 CURSOR l_party_csr Is select object1_id1 from okc_k_party_roles_b where chr_id = p_chr_id and rle_code = 'CUSTOMER';