DBA Data[Home] [Help]

APPS.JTF_RS_IMP_RES_PVT dependencies on JTF_RS_JOB_ROLES

Line 51: CURSOR c_job_roles (l_job_id jtf_rs_job_roles.job_id%type) IS

47:
48: -- fetching the role_type_code in this cursor also so that if salesrep is not created then
49: -- do not create roles of type SALES_COMP -- bug 3579147
50: -- new cursor added (repuri 04/07/03)
51: CURSOR c_job_roles (l_job_id jtf_rs_job_roles.job_id%type) IS
52: SELECT a.role_id, b.role_type_code
53: FROM jtf_rs_job_roles a,
54: jtf_rs_roles_b b
55: WHERE a.job_id = l_job_id

Line 53: FROM jtf_rs_job_roles a,

49: -- do not create roles of type SALES_COMP -- bug 3579147
50: -- new cursor added (repuri 04/07/03)
51: CURSOR c_job_roles (l_job_id jtf_rs_job_roles.job_id%type) IS
52: SELECT a.role_id, b.role_type_code
53: FROM jtf_rs_job_roles a,
54: jtf_rs_roles_b b
55: WHERE a.job_id = l_job_id
56: AND a.role_id = b.role_id ;
57: