DBA Data[Home] [Help]

APPS.JTF_RS_IMP_RES_PVT dependencies on JTF_RS_ROLES_B

Line 54: jtf_rs_roles_b b

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:
58: CURSOR emp_cur(l_person_id NUMBER) IS