APPS.OKS_EXTWAR_UTIL_PVT dependencies on OKC_CONTACTS

Line 5046: -- ,okc_contacts vc

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
5050: -- And vc.cpl_id = pr.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 5395: FROM okc_contacts con

5391:
5392: CURSOR l_salesrep_csr (l_cpl_id NUMBER)
5393: IS
5394: SELECT 'Y'
5395: FROM okc_contacts con
5396: WHERE con.cpl_id = l_cpl_id
5397: AND con.jtot_object1_code = 'OKX_SALEPERS'
5398: AND con.cro_code IN ('SUP_SALES', 'SALESPERSON')
5399: AND TRUNC (SYSDATE) BETWEEN NVL (con.start_date, SYSDATE - 1)

Line 5655: FROM okc_contacts con1, jtf_rs_salesreps salesrep

5651: p_org_id IN NUMBER
5652: )
5653: IS
5654: SELECT con1.ID
5655: FROM okc_contacts con1, jtf_rs_salesreps salesrep
5656: WHERE con1.dnz_chr_id = p_contract_id
5657: AND jtot_object1_code = 'OKX_SALEPERS'
5658: AND con1.cpl_id = p_party_id
5659: AND TRUNC (SYSDATE) BETWEEN NVL (con1.start_date, SYSDATE - 1)

Line 5663: FROM okc_contacts con2

5659: AND TRUNC (SYSDATE) BETWEEN NVL (con1.start_date, SYSDATE - 1)
5660: AND NVL (con1.end_date, SYSDATE)
5661: AND NVL (con1.start_date, TO_DATE (1, 'J')) IN (
5662: SELECT MAX (NVL (con2.start_date, TO_DATE (1, 'J')))
5663: FROM okc_contacts con2
5664: WHERE con2.dnz_chr_id = p_contract_id
5665: AND jtot_object1_code = 'OKX_SALEPERS'
5666: AND con2.cpl_id = p_party_id
5667: AND TRUNC (SYSDATE) BETWEEN NVL (con2.start_date,