DBA Data[Home] [Help]

APPS.OKL_DEAL_PARTIES_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 66: FROM OKC_K_PARTY_ROLES_B

62: AND rgrdfs.sre_id = sre.id;
63:
64: CURSOR c_label_holder(p_chr_id NUMBER, p_rle_code VARCHAR2) IS
65: SELECT 'Y'
66: FROM OKC_K_PARTY_ROLES_B
67: WHERE dnz_chr_id = p_chr_id
68: AND chr_id = p_chr_id
69: AND rle_code = p_rle_code;
70:

Line 391: FROM okc_k_party_roles_b okc_party_roles,

387: okl_party_roles.attribute1,okl_party_roles.attribute2,okl_party_roles.attribute3,okl_party_roles.attribute4,
388: okl_party_roles.attribute5,okl_party_roles.attribute6,okl_party_roles.attribute7,okl_party_roles.attribute8,
389: okl_party_roles.attribute9,okl_party_roles.attribute10,okl_party_roles.attribute11,okl_party_roles.attribute12,
390: okl_party_roles.attribute13,okl_party_roles.attribute14,okl_party_roles.attribute15
391: FROM okc_k_party_roles_b okc_party_roles,
392: okl_k_party_roles okl_party_roles
393: WHERE okc_party_roles.dnz_chr_id = p_chr_id
394: AND okc_party_roles.cle_id is null
395: AND okc_party_roles.rle_code = p_rle_code