APPS.OKS_EXTWAR_UTIL_PVT dependencies on OKC_CONTACTS

Line 5000: -- ,okc_contacts vc

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

5345:
5346: CURSOR l_salesrep_csr (l_cpl_id NUMBER)
5347: IS
5348: SELECT 'Y'
5349: FROM okc_contacts con
5350: WHERE con.cpl_id = l_cpl_id
5351: AND con.jtot_object1_code = 'OKX_SALEPERS'
5352: AND con.cro_code IN ('SUP_SALES', 'SALESPERSON')
5353: AND TRUNC (SYSDATE) BETWEEN NVL (con.start_date, SYSDATE - 1)

Line 5609: FROM okc_contacts con1, jtf_rs_salesreps salesrep

5605: p_org_id IN NUMBER
5606: )
5607: IS
5608: SELECT con1.ID
5609: FROM okc_contacts con1, jtf_rs_salesreps salesrep
5610: WHERE con1.dnz_chr_id = p_contract_id
5611: AND jtot_object1_code = 'OKX_SALEPERS'
5612: AND con1.cpl_id = p_party_id
5613: AND TRUNC (SYSDATE) BETWEEN NVL (con1.start_date, SYSDATE - 1)

Line 5617: FROM okc_contacts con2

5613: AND TRUNC (SYSDATE) BETWEEN NVL (con1.start_date, SYSDATE - 1)
5614: AND NVL (con1.end_date, SYSDATE)
5615: AND NVL (con1.start_date, TO_DATE (1, 'J')) IN (
5616: SELECT MAX (NVL (con2.start_date, TO_DATE (1, 'J')))
5617: FROM okc_contacts con2
5618: WHERE con2.dnz_chr_id = p_contract_id
5619: AND jtot_object1_code = 'OKX_SALEPERS'
5620: AND con2.cpl_id = p_party_id
5621: AND TRUNC (SYSDATE) BETWEEN NVL (con2.start_date,