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 1650: AND cro_code IN (SELECT cro_code FROM okc_contact_sources

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

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

4831: FROM okc_contacts ctc, fnd_user fnd,
4832: jtf_rs_resource_extns rsc, jtf_rs_salesreps srp
4833: WHERE ctc.dnz_chr_id = cp_chr_id
4834: AND ctc.cpl_id = cp_cpl_id
4835: AND ctc.cro_code IN (SELECT src.cro_code FROM okc_contact_sources src
4836: WHERE src.rle_code IN ('VENDOR', 'MERCHANT')
4837: AND src.jtot_object_code = 'OKX_SALEPERS'
4838: AND src.buy_or_sell = 'S')
4839: AND srp.salesrep_id = to_number(ctc.object1_id1)