APPS.CS_UWQ_DISTRIBUTE_ITEMS dependencies on JTF_RS_RESOURCE_EXTNS

Line 57: FROM jtf_rs_resource_extns

53: WHERE incident_id = l_request_id;
54:
55: CURSOR sel_resource_type_csr IS
56: SELECT 'RS_' || category
57: FROM jtf_rs_resource_extns
58: WHERE RESOURCE_ID = P_RESOURCE_ID;
59:
60: CURSOR sel_wi_owner_csr(l_request_id IN NUMBER) IS
61: SELECT assignee_id

Line 489: FROM jtf_rs_resource_extns

485: sel_tasks_rec sel_tasks_csr%ROWTYPE;
486:
487: CURSOR sel_jtf_category_csr(p_resource_id IN NUMBER) IS
488: SELECT 'RS_' || CATEGORY
489: FROM jtf_rs_resource_extns
490: WHERE RESOURCE_ID = p_resource_id;
491:
492: l_category VARCHAR2(35);
493:

Line 604: -- from jtf_rs_resource_extns

600: x_return_status := 'E';
601: ELSE
602:
603: -- obtain the owner_type_code by concatenating 'RS_' and the category
604: -- from jtf_rs_resource_extns
605: OPEN sel_jtf_category_csr(P_RESOURCE_ID);
606: FETCH sel_jtf_category_csr INTO l_category;
607: IF (sel_jtf_category_csr%NOTFOUND) THEN
608: l_category := 'RS_EMPLOYEE';