APPS.OKS_RENEW_CONTRACT_PVT dependencies on OKC_CONTACT_SOURCES

Line 1368: FROM okc_contact_sources

1364:
1365: --gets the cro_code for vendor/merchant contact source based on OKX_SALEPERS
1366: CURSOR c_get_cro_code(cp_rle_code IN VARCHAR2) IS
1367: SELECT cro_code
1368: FROM okc_contact_sources
1369: WHERE buy_or_sell = 'S' AND rle_code = cp_rle_code
1370: AND jtot_object_code = 'OKX_SALEPERS'
1371: AND SYSDATE BETWEEN start_date AND NVL(end_date,SYSDATE + 1) ; -- bug 5938308
1372:

Line 1651: AND cro_code IN (SELECT cro_code FROM okc_contact_sources

1647: --delete any old vendor/merchant contacts based on jtf object OKX_SALEPERS
1648: DELETE FROM okc_contacts
1649: WHERE dnz_chr_id = p_chr_id
1650: AND cpl_id = l_cpl_id
1651: AND cro_code IN (SELECT cro_code FROM okc_contact_sources
1652: WHERE buy_or_sell = 'S' AND rle_code = l_rle_code
1653: AND jtot_object_code = 'OKX_SALEPERS');
1654:
1655: --add this salesrep as a contact for vendor/merchant with the cro_code found above

Line 4870: AND ctc.cro_code IN (SELECT src.cro_code FROM okc_contact_sources src

4866: FROM okc_contacts ctc, fnd_user fnd,
4867: jtf_rs_resource_extns rsc, jtf_rs_salesreps srp
4868: WHERE ctc.dnz_chr_id = cp_chr_id
4869: AND ctc.cpl_id = cp_cpl_id
4870: AND ctc.cro_code IN (SELECT src.cro_code FROM okc_contact_sources src
4871: WHERE src.rle_code IN ('VENDOR', 'MERCHANT')
4872: AND src.jtot_object_code = 'OKX_SALEPERS'
4873: AND src.buy_or_sell = 'S')
4874: AND srp.salesrep_id = to_number(ctc.object1_id1)