40: l_manager_name varchar2(30);
41:
42: CURSOR c_get_manager(p_user_id NUMBER) IS
43: SELECT b.user_id, b.user_name
44: FROM JTF_RS_RESOURCE_EXTNS a
45: ,JTF_RS_RESOURCE_EXTNS b
46: WHERE b.source_id = a.source_mgr_id
47: AND a.user_id = p_user_id;
48:
41:
42: CURSOR c_get_manager(p_user_id NUMBER) IS
43: SELECT b.user_id, b.user_name
44: FROM JTF_RS_RESOURCE_EXTNS a
45: ,JTF_RS_RESOURCE_EXTNS b
46: WHERE b.source_id = a.source_mgr_id
47: AND a.user_id = p_user_id;
48:
49: BEGIN
216: l_manager_name varchar2(30);
217:
218: CURSOR c_get_manager(p_user_id NUMBER) IS
219: SELECT b.user_id, b.user_name
220: FROM JTF_RS_RESOURCE_EXTNS a
221: ,JTF_RS_RESOURCE_EXTNS b
222: WHERE b.source_id = a.source_mgr_id
223: AND a.user_id = p_user_id;
224:
217:
218: CURSOR c_get_manager(p_user_id NUMBER) IS
219: SELECT b.user_id, b.user_name
220: FROM JTF_RS_RESOURCE_EXTNS a
221: ,JTF_RS_RESOURCE_EXTNS b
222: WHERE b.source_id = a.source_mgr_id
223: AND a.user_id = p_user_id;
224:
225: BEGIN