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 3515: OKC_K_PARTY_ROLES_B PARTY_ROLE

3511: TOP_KLE.AMOUNT original_Stake,
3512: TOP_KLE.AMOUNT_STAKE additional_Stake
3513: FROM OKC_K_LINES_B TOP_LINE,
3514: OKL_K_LINES TOP_KLE,
3515: OKC_K_PARTY_ROLES_B PARTY_ROLE
3516: WHERE TOP_LINE.dnz_chr_id = p_khr_id
3517: AND TOP_KLE.ID = TOP_LINE.ID
3518: AND PARTY_ROLE.cle_id = TOP_LINE.id
3519: AND PARTY_ROLE.dnz_chr_id = TOP_LINE.dnz_chr_id

Line 4302: OKC_K_PARTY_ROLES_B PARTY_ROLE

4298: TOP_KLE.AMOUNT original_Stake,
4299: TOP_KLE.AMOUNT_STAKE additional_Stake
4300: FROM OKC_K_LINES_B TOP_LINE,
4301: OKL_K_LINES TOP_KLE,
4302: OKC_K_PARTY_ROLES_B PARTY_ROLE
4303: WHERE TOP_LINE.dnz_chr_id = p_khr_id
4304: AND TOP_KLE.ID = TOP_LINE.ID
4305: AND PARTY_ROLE.cle_id = TOP_LINE.id
4306: AND PARTY_ROLE.dnz_chr_id = TOP_LINE.dnz_chr_id