APPS.JTF_RS_CONC_RES_PUB dependencies on JTF_RS_ROLE_RELATIONS

Line 278: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;

274: s_msg_data VARCHAR2(2000);
275:
276: l_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;
277: m_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;
278: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
279:
280: CURSOR c_salesrep_number (l_salesrep_number jtf_rs_salesreps.salesrep_number%TYPE) IS
281: SELECT salesrep_id FROM jtf_rs_salesreps
282: WHERE salesrep_number = l_salesrep_number;

Line 1787: FROM jtf_rs_role_relations rr

1783: -- WHERE name = l_job_name;
1784:
1785: CURSOR c_job_role_relations (l_role_id IN NUMBER, l_resource_id IN NUMBER) IS
1786: SELECT rr.role_relate_id, rr.object_version_number
1787: FROM jtf_rs_role_relations rr
1788: WHERE rr.role_resource_type = 'RS_INDIVIDUAL'
1789: AND rr.role_resource_id = l_resource_id
1790: AND rr.role_id = l_role_id
1791: AND nvl(rr.delete_flag,'N') <> 'Y'

Line 1801: FROM jtf_rs_role_relations rr

1797: and also the role exists in job roles table. Bug # 3300409 */
1798:
1799: CURSOR c_res_roles_enddate (l_resource_id IN NUMBER, l_new_role_st_dt DATE) IS
1800: SELECT rr.role_relate_id, rr.object_version_number, rr.role_id
1801: FROM jtf_rs_role_relations rr
1802: WHERE exists (select null
1803: from jtf_rs_job_roles jr
1804: where jr.role_id = rr.role_id
1805: and jr.job_id not in (nvl(p_old_job_id,-99)))