APPS.JTF_RS_CONC_RES_PUB dependencies on JTF_RS_JOB_ROLES

Line 284: CURSOR c_job_roles (l_job_id jtf_rs_job_roles.job_id%TYPE) IS

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;
283:
284: CURSOR c_job_roles (l_job_id jtf_rs_job_roles.job_id%TYPE) IS
285: SELECT role_id
286: FROM jtf_rs_job_roles
287: WHERE job_id = l_job_id;
288:

Line 286: FROM jtf_rs_job_roles

282: WHERE salesrep_number = l_salesrep_number;
283:
284: CURSOR c_job_roles (l_job_id jtf_rs_job_roles.job_id%TYPE) IS
285: SELECT role_id
286: FROM jtf_rs_job_roles
287: WHERE job_id = l_job_id;
288:
289: CURSOR c_role_name (l_role_id jtf_rs_roles_vl.role_id%TYPE) IS
290: SELECT role_name

Line 1751: FROM jtf_rs_job_roles

1747: l_g_miss_date date;
1748:
1749: CURSOR c_job_roles (l_job_id IN NUMBER) IS
1750: SELECT role_id
1751: FROM jtf_rs_job_roles
1752: WHERE job_id = l_job_id;
1753:
1754: l_job_roles_rec c_job_roles%ROWTYPE;
1755:

Line 1803: from jtf_rs_job_roles jr

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)))
1806: AND rr.role_resource_type = 'RS_INDIVIDUAL'
1807: AND rr.role_resource_id = l_resource_id