APPS.OKS_OC_INT_KTO_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 97: FROM okc_k_party_roles_b cpr

93: ,cpr.jtot_object1_code
94: ,cpr.object1_id1
95: ,cpr.object1_id2
96: ,cpr.rle_code
97: FROM okc_k_party_roles_b cpr
98: ,okc_role_sources rsc
99: WHERE
100: rsc.buy_or_sell = 'S' -- sell contract
101: AND rsc.rle_code = cpr.rle_code -- role

Line 1354: okc_k_party_roles_b pr

1350: hdr.id,
1351: hdr.contract_number
1352: from
1353: okc_k_headers_b hdr,
1354: okc_k_party_roles_b pr
1355: where hdr.id = nvl(p_contract_id ,hdr.id)
1356: and hdr.id between nvl(nvl(p_contract_id,p_contract_hdr_id_lo),hdr.id)
1357: and nvl(nvl(p_contract_id,p_contract_hdr_id_hi),hdr.id)
1358: And pr.chr_id = hdr.id

Line 1402: okc_k_party_roles_b pr,

1398: sub.om_interface_date,
1399: hdr.contract_number
1400: from oks_subscr_elements sub,
1401: okc_k_headers_b hdr,
1402: okc_k_party_roles_b pr,
1403: okc_statuses_b st
1404: where sub.dnz_chr_id = nvl(p_contract_id ,sub.dnz_chr_id)
1405: --== and sub.dnz_chr_id between nvl(nvl(p_contract_id,p_contract_hdr_id_lo),sub.dnz_chr_id)
1406: --== and nvl(nvl(p_contract_id,p_contract_hdr_id_hi),sub.dnz_chr_id)