APPS.OKS_RENEW_CONTRACT_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 1346: FROM jtf_rs_salesreps s , jtf_rs_resource_extns_vl v

1342:
1343: --same salesrep can be defined for multiple orgs - so check
1344: CURSOR c_check_org_match(cp_salesrep_id IN NUMBER, cp_org_id IN NUMBER) IS /*bugfix for 6672863 */
1345: SELECT s.org_id, v.resource_name
1346: FROM jtf_rs_salesreps s , jtf_rs_resource_extns_vl v
1347: WHERE s.resource_id = v.resource_id
1348: AND s.salesrep_id = cp_salesrep_id
1349: AND org_id = cp_org_id; /*bugfix for 6672863*/
1350:

Line 1402: l_salesrep_name jtf_rs_resource_extns_vl.resource_name%TYPE;

1398: l_created_by NUMBER;
1399: l_login_id NUMBER;
1400: l_id_tbl num_tbl_type;
1401:
1402: l_salesrep_name jtf_rs_resource_extns_vl.resource_name%TYPE;
1403: l_org_name hr_all_organization_units.name%TYPE;
1404: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1405:
1406: BEGIN

Line 4867: jtf_rs_resource_extns rsc, jtf_rs_salesreps srp

4863: SELECT
4864: --rsc.resource_id, srp.salesrep_id, srp.org_id, ctc.cro_code,
4865: fnd.user_id, fnd.user_name
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')