APPS.JTF_RS_CONC_RES_PUB dependencies on JTF_RS_ROLE_RELATIONS

Line 336: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;

332: s_msg_data VARCHAR2(2000);
333:
334: l_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;
335: m_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;
336: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
337:
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;

Line 1885: FROM jtf_rs_role_relations rr

1881: -- WHERE name = l_job_name;
1882:
1883: CURSOR c_job_role_relations (l_role_id IN NUMBER, l_resource_id IN NUMBER) IS
1884: SELECT rr.role_relate_id, rr.object_version_number,start_date_active
1885: FROM jtf_rs_role_relations rr
1886: WHERE rr.role_resource_type = 'RS_INDIVIDUAL'
1887: AND rr.role_resource_id = l_resource_id
1888: AND rr.role_id = l_role_id
1889: AND nvl(rr.delete_flag,'N') <> 'Y'

Line 1896: FROM jtf_rs_role_relations rr

1892: l_job_role_relations_rec c_job_role_relations%ROWTYPE;
1893:
1894: CURSOR c_existing_role_relations (l_role_id IN NUMBER, l_resource_id IN NUMBER,l_asg_start_date IN DATE,l_asg_end_date IN DATE) IS
1895: SELECT rr.role_relate_id, rr.object_version_number,start_date_active,end_date_active
1896: FROM jtf_rs_role_relations rr
1897: WHERE rr.role_resource_type = 'RS_INDIVIDUAL'
1898: AND rr.role_resource_id = l_resource_id
1899: AND rr.role_id = l_role_id
1900: AND nvl(rr.delete_flag,'N') <> 'Y'

Line 1916: FROM jtf_rs_role_relations rr

1912: --Bug13682589
1913: /* In below cursor job_id condition changed from NOT IN to IN for old job_id */
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)))