APPS.OKE_IMPORT_CONTRACT_PUB dependencies on OKC_K_PARTY_ROLES_B

Line 3700: (select id from okc_k_party_roles_b where cle_id=p_contract_line_id);

3696: -- We need to delete corresonding clauses from the okc_articles_all first?
3697:
3698: -- Delete parties and contacts
3699: delete from okc_contacts where cpl_id in
3700: (select id from okc_k_party_roles_b where cle_id=p_contract_line_id);
3701:
3702: delete from okc_k_party_roles_tl where id in
3703: (select id from okc_k_party_roles_b where cle_id=p_contract_line_id);
3704:

Line 3703: (select id from okc_k_party_roles_b where cle_id=p_contract_line_id);

3699: delete from okc_contacts where cpl_id in
3700: (select id from okc_k_party_roles_b where cle_id=p_contract_line_id);
3701:
3702: delete from okc_k_party_roles_tl where id in
3703: (select id from okc_k_party_roles_b where cle_id=p_contract_line_id);
3704:
3705: delete from okc_k_party_roles_b where cle_id = p_contract_line_id;
3706:
3707:

Line 3705: delete from okc_k_party_roles_b where cle_id = p_contract_line_id;

3701:
3702: delete from okc_k_party_roles_tl where id in
3703: (select id from okc_k_party_roles_b where cle_id=p_contract_line_id);
3704:
3705: delete from okc_k_party_roles_b where cle_id = p_contract_line_id;
3706:
3707:
3708:
3709: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,