APPS.OKS_RENEW_CONTRACT_PVT dependencies on JTF_RS_RESOURCE_EXTNS_VL

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