APPS.OKL_VENDOR_AGREEMENT_PUB SQL Statements

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

Line: 59

	SELECT rso.jtot_object_code
      FROM   okc_subclass_roles sre,
             okc_role_sources rso
      WHERE  sre.scs_code = p_category
      AND    rso.rle_code = sre.rle_code
      AND    rso.rle_code = p_rle_code
      AND    rso.buy_or_sell = 'S';

Line: 70

	SELECT jtot_object_code
	FROM   okc_contact_sources
	WHERE  rle_code = p_party_role_code
	AND    buy_or_sell = 'S'
	AND    CRO_CODE = p_contact_role_code;

Line: 80

	SELECT id
	FROM   OKC_K_PARTY_ROLES_B
	WHERE  chr_id = p_chr_id
	AND    object1_id1 = p_party_role_id
	AND    rle_code = p_party_role_code;

Line: 88

    select id
    from okc_rg_role_defs
    where sre_id = (select id
                    from okc_subclass_roles
                    where scs_code = 'PROGRAM' and rle_code = 'OKL_VENDOR')
    and srd_id = (  select id
                    from okc_subclass_rg_defs
                    where scs_code = 'PROGRAM' and rgd_code = 'LAVENB');

Line: 101

	select sar.id
	from   okc_std_articles_v sar,
	       okc_std_art_versions_v svr
	where  sar.id = svr.sae_id
	and    sar.name = p_name
	and    svr.sav_release = p_version;

Line: 296

      OKL_CONTRACT_PARTY_PUB.update_k_party_role(
                    p_api_version	=> p_api_version,
                    p_init_msg_list	=> p_init_msg_list,
                    x_return_status	=> x_return_status,
                    x_msg_count	=> x_msg_count,
                    x_msg_data	=> x_msg_data,
                    p_cplv_rec	=> l_cplv_rec,
                    x_cplv_rec	=> lx_cplv_rec);

Line: 307

      l_rgr_tbl.DELETE;