APPS.OKS_EXTWAR_UTIL_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 2826: okc_k_party_roles_b party

2822: oks_k_headers_b ks,
2823: okc_k_lines_v kl,
2824: oks_k_lines_b okl,
2825: okc_statuses_v st,
2826: okc_k_party_roles_b party
2827: WHERE ki.object1_id1 = p_id
2828: AND ki.jtot_object1_code = p_code
2829: AND ki.dnz_chr_id = kh.ID
2830: AND ks.chr_id(+) = kh.ID -- Vigandhi 06-jan-2004

Line 4999: -- ,okc_k_party_roles_B pr

4995: -- Cursor l_chr_csr Is
4996: -- select vc.object1_id1
4997: -- ,kh.authoring_org_id
4998: -- From okc_k_headers_b kh
4999: -- ,okc_k_party_roles_B pr
5000: -- ,okc_contacts vc
5001: -- Where kh.id = p_contract_id
5002: -- And pr.chr_id = p_contract_id
5003: -- And vc.dnz_chr_id = p_contract_id

Line 5012: FROM okc_k_headers_b kh, okc_k_party_roles_b pr, okc_contacts vc

5008: -- and nvl(vc.end_date,sysdate) ;
5009: CURSOR l_chr_csr
5010: IS
5011: SELECT vc.object1_id1, kh.authoring_org_id
5012: FROM okc_k_headers_b kh, okc_k_party_roles_b pr, okc_contacts vc
5013: WHERE kh.ID = p_contract_id
5014: AND pr.chr_id = p_contract_id
5015: AND vc.dnz_chr_id = p_contract_id
5016: AND vc.cpl_id = pr.ID

Line 5337: FROM okc_k_party_roles_b ven, okc_k_party_roles_b cust

5333:
5334: CURSOR l_party_csr (l_chr_id NUMBER)
5335: IS
5336: SELECT ven.object1_id1, ven.ID, cust.object1_id1
5337: FROM okc_k_party_roles_b ven, okc_k_party_roles_b cust
5338: WHERE ven.dnz_chr_id = cust.dnz_chr_id
5339: AND ven.dnz_chr_id = l_chr_id
5340: AND ven.cle_id IS NULL
5341: AND ven.rle_code = 'VENDOR'