DBA Data[Home] [Help]

APPS.OKL_AM_PARTIES_PVT dependencies on OKC_CONTACTS

Line 1914: FROM okc_contacts cn,

1910: cp_contract_id NUMBER) IS
1911: SELECT cn.jtot_object1_code,
1912: cn.object1_id1,
1913: cn.object1_id2
1914: FROM okc_contacts cn,
1915: okc_contact_sources cs
1916: WHERE cn.cpl_id = cp_k_party_id
1917: AND cn.dnz_chr_id = cp_contract_id
1918: AND cn.cro_code = cs.cro_code

Line 2692: FROM okc_contacts cn

2688: CURSOR l_chr_contacts_csr (cp_k_party_id NUMBER) IS
2689: SELECT cn.jtot_object1_code,
2690: cn.object1_id1,
2691: cn.object1_id2
2692: FROM okc_contacts cn
2693: WHERE cn.cpl_id = cp_k_party_id
2694: AND NVL (cn.start_date, SYSDATE) <= SYSDATE
2695: AND NVL (cn.end_date, SYSDATE) >= SYSDATE;
2696: