APPS.JTF_RS_CONC_RES_PUB dependencies on JTF_RS_JOB_ROLES

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

338: CURSOR c_salesrep_number (l_salesrep_number jtf_rs_salesreps.salesrep_number%TYPE) IS
339: SELECT salesrep_id FROM jtf_rs_salesreps
340: WHERE salesrep_number = l_salesrep_number;
341:
342: CURSOR c_job_roles (l_job_id jtf_rs_job_roles.job_id%TYPE) IS
343: SELECT role_id
344: FROM jtf_rs_job_roles
345: WHERE job_id = l_job_id;
346:

Line 344: FROM jtf_rs_job_roles

340: WHERE salesrep_number = l_salesrep_number;
341:
342: CURSOR c_job_roles (l_job_id jtf_rs_job_roles.job_id%TYPE) IS
343: SELECT role_id
344: FROM jtf_rs_job_roles
345: WHERE job_id = l_job_id;
346:
347: CURSOR c_role_name (l_role_id jtf_rs_roles_vl.role_id%TYPE) IS
348: SELECT role_name

Line 1849: FROM jtf_rs_job_roles

1845: l_g_miss_date date;
1846:
1847: CURSOR c_job_roles (l_job_id IN NUMBER) IS
1848: SELECT role_id
1849: FROM jtf_rs_job_roles
1850: WHERE job_id = l_job_id;
1851:
1852: l_job_roles_rec c_job_roles%ROWTYPE;
1853:

Line 1918: from jtf_rs_job_roles jr

1914: CURSOR c_res_roles_enddate (l_resource_id IN NUMBER, l_new_role_st_dt DATE) IS
1915: SELECT rr.role_relate_id, rr.object_version_number, rr.role_id ,start_date_active
1916: FROM jtf_rs_role_relations rr
1917: WHERE exists (select null
1918: from jtf_rs_job_roles jr
1919: where jr.role_id = rr.role_id
1920: and jr.job_id in (nvl(p_old_job_id,-99)))
1921: AND rr.role_resource_type = 'RS_INDIVIDUAL'
1922: AND rr.role_resource_id = l_resource_id