APPS.OKC_OPPORTUNITY_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 145: cursor c2(p_rle_code okc_k_party_roles_b.rle_code%TYPE) is

141: and rel.chr_id(+) = h.orig_system_id1
142: and rel.rty_code(+) = 'OPPEXPSCONTRACT'
143: and rel.jtot_object1_code(+) = 'OKX_OPPHEAD';
144: --
145: cursor c2(p_rle_code okc_k_party_roles_b.rle_code%TYPE) is
146: select object1_id1
147: from okc_k_party_roles_b
148: where dnz_chr_id = p_contract_id
149: and cle_id is null

Line 147: from okc_k_party_roles_b

143: and rel.jtot_object1_code(+) = 'OKX_OPPHEAD';
144: --
145: cursor c2(p_rle_code okc_k_party_roles_b.rle_code%TYPE) is
146: select object1_id1
147: from okc_k_party_roles_b
148: where dnz_chr_id = p_contract_id
149: and cle_id is null
150: and rle_code = p_rle_code;
151: --

Line 1141: cursor cpl_csr (p_rle_code in okc_k_party_roles_b.rle_code%TYPE) is

1137: and scs.code = chrb.scs_code
1138: and sts.code = chrb.sts_code;
1139: k_rec k_csr%ROWTYPE;
1140: --
1141: cursor cpl_csr (p_rle_code in okc_k_party_roles_b.rle_code%TYPE) is
1142: select 'x'
1143: from okc_k_party_roles_b
1144: where dnz_chr_id = p_contract_id
1145: and cle_id is null

Line 1143: from okc_k_party_roles_b

1139: k_rec k_csr%ROWTYPE;
1140: --
1141: cursor cpl_csr (p_rle_code in okc_k_party_roles_b.rle_code%TYPE) is
1142: select 'x'
1143: from okc_k_party_roles_b
1144: where dnz_chr_id = p_contract_id
1145: and cle_id is null
1146: and rle_code = p_rle_code;
1147: --