DBA Data[Home] [Help]

APPS.OKL_AM_PARTIES_PVT dependencies on OKC_CONTACT_SOURCES

Line 1900: FROM okc_contact_sources cs

1896: l_contact_object VARCHAR2(30);
1897:
1898: CURSOR l_cntct_src_count_csr (cp_rle_code VARCHAR2, cp_buy_or_sell VARCHAR2) IS
1899: SELECT count(*)
1900: FROM okc_contact_sources cs
1901: WHERE cs.rle_code = cp_rle_code
1902: AND cs.start_date <= SYSDATE
1903: AND NVL (cs.end_date, SYSDATE) >= SYSDATE
1904: AND cs.buy_or_sell = cp_buy_or_sell;

Line 1915: okc_contact_sources cs

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
1919: AND cn.jtot_object1_code = cs.jtot_object_code