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 478: FROM jtf_rs_resource_extns

474: sel_tasks_rec sel_tasks_csr%ROWTYPE;
475:
476: CURSOR sel_jtf_category_csr(p_resource_id IN NUMBER) IS
477: SELECT 'RS_' || CATEGORY
478: FROM jtf_rs_resource_extns
479: WHERE RESOURCE_ID = p_resource_id;
480:
481: l_category VARCHAR2(35);
482:

Line 593: -- from jtf_rs_resource_extns

589: x_return_status := 'E';
590: ELSE
591:
592: -- obtain the owner_type_code by concatenating 'RS_' and the category
593: -- from jtf_rs_resource_extns
594: OPEN sel_jtf_category_csr(P_RESOURCE_ID);
595: FETCH sel_jtf_category_csr INTO l_category;
596: IF (sel_jtf_category_csr%NOTFOUND) THEN
597: l_category := 'RS_EMPLOYEE';