APPS.OKS_EXTWAR_UTIL_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 2872: okc_k_party_roles_b party

2868: oks_k_headers_b ks,
2869: okc_k_lines_v kl,
2870: oks_k_lines_b okl,
2871: okc_statuses_v st,
2872: okc_k_party_roles_b party
2873: WHERE ki.object1_id1 = p_id
2874: AND ki.jtot_object1_code = p_code
2875: AND ki.dnz_chr_id = kh.ID
2876: AND ks.chr_id(+) = kh.ID -- Vigandhi 06-jan-2004

Line 5045: -- ,okc_k_party_roles_B pr

5041: -- Cursor l_chr_csr Is
5042: -- select vc.object1_id1
5043: -- ,kh.authoring_org_id
5044: -- From okc_k_headers_b kh
5045: -- ,okc_k_party_roles_B pr
5046: -- ,okc_contacts vc
5047: -- Where kh.id = p_contract_id
5048: -- And pr.chr_id = p_contract_id
5049: -- And vc.dnz_chr_id = p_contract_id

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

5054: -- and nvl(vc.end_date,sysdate) ;
5055: CURSOR l_chr_csr
5056: IS
5057: SELECT vc.object1_id1, kh.authoring_org_id
5058: FROM okc_k_headers_b kh, okc_k_party_roles_b pr, okc_contacts vc
5059: WHERE kh.ID = p_contract_id
5060: AND pr.chr_id = p_contract_id
5061: AND vc.dnz_chr_id = p_contract_id
5062: AND vc.cpl_id = pr.ID

Line 5383: FROM okc_k_party_roles_b ven, okc_k_party_roles_b cust

5379:
5380: CURSOR l_party_csr (l_chr_id NUMBER)
5381: IS
5382: SELECT ven.object1_id1, ven.ID, cust.object1_id1
5383: FROM okc_k_party_roles_b ven, okc_k_party_roles_b cust
5384: WHERE ven.dnz_chr_id = cust.dnz_chr_id
5385: AND ven.dnz_chr_id = l_chr_id
5386: AND ven.cle_id IS NULL
5387: AND ven.rle_code = 'VENDOR'