APPS.OKL_CS_WF dependencies on OKC_K_PARTY_ROLES_B

Line 610: FROM okc_k_party_roles_b

606: --Cursor for obtaining the party name on the old contract
607: CURSOR c_party(p_contract_id IN NUMBER) IS
608: SELECT object1_id1,
609: object1_id2
610: FROM okc_k_party_roles_b
611: WHERE dnz_chr_id = p_contract_id
612: AND rle_code = 'LESSEE';
613:
614: CURSOR c_lessee(p_id1 IN VARCHAR2,

Line 1780: okc_k_party_roles_b pr

1776: CURSOR c_contact_role(p_contract_id IN NUMBER) IS
1777: SELECT co.object1_id1,
1778: co.jtot_object1_code
1779: FROM okc_contacts_v co,
1780: okc_k_party_roles_b pr
1781: WHERE co.dnz_chr_id = p_contract_id
1782: AND co.cpl_id = pr.id
1783: AND co.dnz_chr_id = pr.dnz_chr_id
1784: AND pr.rle_code = 'OKL_VENDOR';