The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT rgrdfs.id
FROM okc_k_headers_b chr,
okc_subclass_roles sre,
okc_role_sources rse,
okc_subclass_rg_defs rgdfs,
okc_rg_role_defs rgrdfs
WHERE chr.id = p_chr_id
AND sre.scs_code = chr.scs_code
AND sre.rle_code = rse.rle_code
AND rse.rle_code = p_rle_code
AND rse.buy_or_sell = chr.buy_or_sell
AND rgdfs.scs_code = chr.scs_code
AND rgdfs.rgd_code = p_rgd_code
AND rgrdfs.srd_id = rgdfs.id
AND rgrdfs.sre_id = sre.id;
SELECT 'Y'
FROM OKC_K_PARTY_ROLES_B
WHERE dnz_chr_id = p_chr_id
AND chr_id = p_chr_id
AND rle_code = p_rle_code;
OKL_K_PARTY_ROLES_PVT.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 => lp_cplv_rec,
x_cplv_rec => lx_cplv_rec,
p_kplv_rec => lp_kplv_rec,
x_kplv_rec => lx_kplv_rec);
OKL_RULE_PUB.update_rule_group(
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_rgpv_rec => lp_lalabl_rgpv_rec,
x_rgpv_rec => lx_lalabl_rgpv_rec);
OKL_RULE_PUB.update_rule(
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_rulv_rec => lp_lalogo_rulv_rec,
x_rulv_rec => lx_lalogo_rulv_rec);
SELECT rul.rgp_id,rgp.rgd_code,rul.ID,rul.object1_id1,rul.object1_id2,rul.jtot_object1_code,
rul.rule_information_category,rul.rule_information1,rul.rule_information2,rul.rule_information3,
rul.rule_information4
FROM okc_rules_b rul,
okc_rule_groups_b rgp
WHERE rgp.chr_id = p_chr_id
AND rgp.id = p_rgp_id
AND rgp.dnz_chr_id = p_chr_id
AND rgp.rgd_code = p_rgd_code
AND rgp.id = rul.rgp_id
AND rgp.dnz_chr_id = rul.dnz_chr_id
AND rul.rule_information_category = p_rule_info_cat;
SELECT okc_party_roles.id,object1_id1,object1_id2,jtot_object1_code,okl_party_roles.attribute_category,
okl_party_roles.attribute1,okl_party_roles.attribute2,okl_party_roles.attribute3,okl_party_roles.attribute4,
okl_party_roles.attribute5,okl_party_roles.attribute6,okl_party_roles.attribute7,okl_party_roles.attribute8,
okl_party_roles.attribute9,okl_party_roles.attribute10,okl_party_roles.attribute11,okl_party_roles.attribute12,
okl_party_roles.attribute13,okl_party_roles.attribute14,okl_party_roles.attribute15
FROM okc_k_party_roles_b okc_party_roles,
okl_k_party_roles okl_party_roles
WHERE okc_party_roles.dnz_chr_id = p_chr_id
AND okc_party_roles.cle_id is null
AND okc_party_roles.rle_code = p_rle_code
AND okc_party_roles.id = okl_party_roles.id
AND okc_party_roles.object1_id1 = p_party_id;
SELECT party_site_number
FROM hz_party_sites
WHERE party_site_id = p_party_site_id;
SELECT party_name
FROM hz_parties
WHERE party_id = p_party_id;
SELECT rgrdfs.id
FROM okc_k_headers_b chr,
okc_subclass_roles sre,
okc_role_sources rse,
okc_subclass_rg_defs rgdfs,
okc_rg_role_defs rgrdfs
WHERE chr.id = p_chr_id
AND sre.scs_code = chr.scs_code
AND sre.rle_code = rse.rle_code
AND rse.rle_code = p_rle_code
AND rse.buy_or_sell = chr.buy_or_sell
AND rgdfs.scs_code = chr.scs_code
AND rgdfs.rgd_code = p_rgd_code
AND rgrdfs.srd_id = rgdfs.id
AND rgrdfs.sre_id = sre.id;
SELECT rgp_id
FROM okc_rg_party_roles
WHERE rrd_id = p_rrd_id
AND dnz_chr_id = p_dnz_chr_id
AND cpl_id = p_cpl_id;
SELECT rgrdfs.id
FROM okc_k_headers_b chr,
okc_subclass_roles sre,
okc_role_sources rse,
okc_subclass_rg_defs rgdfs,
okc_rg_role_defs rgrdfs
WHERE chr.id = p_chr_id
AND sre.scs_code = chr.scs_code
AND sre.rle_code = rse.rle_code
AND rse.rle_code = p_rle_code
AND rse.buy_or_sell = chr.buy_or_sell
AND rgdfs.scs_code = chr.scs_code
AND rgdfs.rgd_code = p_rgd_code
AND rgrdfs.srd_id = rgdfs.id
AND rgrdfs.sre_id = sre.id;
OKL_RULE_PUB.update_rule_group(
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_rgpv_rec => lp_lagrdt_rgpv_rec,
x_rgpv_rec => lx_lagrdt_rgpv_rec);
OKL_RULE_PUB.update_rule(
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_rulv_rec => lp_lagrnp_rulv_rec,
x_rulv_rec => lx_lagrnp_rulv_rec);
OKL_RULE_PUB.update_rule(
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_rulv_rec => lp_lagrnt_rulv_rec,
x_rulv_rec => lx_lagrnt_rulv_rec);
OKL_K_PARTY_ROLES_PVT.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 => lp_cplv_rec,
x_cplv_rec => lx_cplv_rec,
p_kplv_rec => lp_kplv_rec,
x_kplv_rec => lx_kplv_rec);