APPS.OKL_SEC_AGREEMENT_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 150: okc_k_party_roles_b pty,

146: Cursor salesP_csr( chrId NUMBER) IS
147: select ct.object1_id1 id
148: from okc_contacts ct,
149: okc_contact_sources csrc,
150: okc_k_party_roles_b pty,
151: okc_k_headers_b chr
152: where ct.cpl_id = pty.id
153: and ct.cro_code = csrc.cro_code
154: and ct.jtot_object1_code = csrc.jtot_object_code

Line 3498: OKC_K_PARTY_ROLES_B PARTY_ROLE

3494: TOP_KLE.AMOUNT original_Stake,
3495: TOP_KLE.AMOUNT_STAKE additional_Stake
3496: FROM OKC_K_LINES_B TOP_LINE,
3497: OKL_K_LINES TOP_KLE,
3498: OKC_K_PARTY_ROLES_B PARTY_ROLE
3499: WHERE TOP_LINE.dnz_chr_id = p_khr_id
3500: AND TOP_KLE.ID = TOP_LINE.ID
3501: AND PARTY_ROLE.cle_id = TOP_LINE.id
3502: AND PARTY_ROLE.dnz_chr_id = TOP_LINE.dnz_chr_id

Line 4274: OKC_K_PARTY_ROLES_B PARTY_ROLE

4270: TOP_KLE.AMOUNT original_Stake,
4271: TOP_KLE.AMOUNT_STAKE additional_Stake
4272: FROM OKC_K_LINES_B TOP_LINE,
4273: OKL_K_LINES TOP_KLE,
4274: OKC_K_PARTY_ROLES_B PARTY_ROLE
4275: WHERE TOP_LINE.dnz_chr_id = p_khr_id
4276: AND TOP_KLE.ID = TOP_LINE.ID
4277: AND PARTY_ROLE.cle_id = TOP_LINE.id
4278: AND PARTY_ROLE.dnz_chr_id = TOP_LINE.dnz_chr_id