APPS.OKS_RENEW_CONTRACT_PVT dependencies on JTF_RS_SALESREPS

Line 1340: FROM jtf_rs_salesreps

1336:
1337: --gets the salesrep id from jtf resource id and k org id
1338: CURSOR c_res_salesrep(cp_res_id IN NUMBER, cp_org_id IN NUMBER) IS
1339: SELECT salesrep_id
1340: FROM jtf_rs_salesreps
1341: WHERE resource_id = cp_res_id AND org_id = cp_org_id;
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 */

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 4832: jtf_rs_resource_extns rsc, jtf_rs_salesreps srp

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