[Home] [Help]
175:
176: CURSOR c_closed_assignments( b_task_id NUMBER ) IS
177: SELECT TASK_ASSIGNMENT_ID
178: , RESOURCE_ID
179: FROM JTF_TASK_ASSIGNMENTS ta
180: , JTF_TASK_STATUSES_B ts
181: WHERE ta.TASK_ID = b_task_id
182: AND ta.ASSIGNEE_ROLE = 'ASSIGNEE'
183: AND ts.TASK_STATUS_ID = ta.ASSIGNMENT_STATUS_ID
259:
260: CURSOR c_closed_assignments( b_task_id NUMBER ) IS
261: SELECT TASK_ASSIGNMENT_ID
262: , RESOURCE_ID
263: FROM JTF_TASK_ASSIGNMENTS ta
264: , JTF_TASK_STATUSES_B ts
265: WHERE ta.TASK_ID = b_task_id
266: AND ta.ASSIGNEE_ROLE = 'ASSIGNEE'
267: AND ts.TASK_STATUS_ID = ta.ASSIGNMENT_STATUS_ID
406: CURSOR c_task_time( b_incident_id NUMBER
407: , b_resource_id NUMBER ) IS
408: SELECT MAX(tk.SCHEDULED_END_DATE ) AS "TASK_TIME"
409: FROM JTF_TASKS_B tk
410: , JTF_TASK_ASSIGNMENTS ta
411: WHERE tk.SOURCE_OBJECT_TYPE_CODE = 'SR'
412: AND tk.SOURCE_OBJECT_ID = b_incident_id
413: AND tk.TASK_ID = ta.TASK_ID
414: AND ta.ASSIGNEE_ROLE = 'ASSIGNEE'
420: SELECT DISTINCT inc.INCIDENT_ID
421: , inc.CLOSE_DATE
422: FROM CS_INCIDENTS_ALL_B inc
423: , JTF_TASKS_B tk
424: , JTF_TASK_ASSIGNMENTS ta
425: , CS_INCIDENT_STATUSES_B ists
426: , JTF_TASK_TYPES_B tt
427: , JTF_TASK_STATUSES_B tkst
428: , JTF_TASK_STATUSES_B tast
455: SELECT DISTINCT inc.INCIDENT_ID
456: , inc.CLOSE_DATE
457: FROM CS_INCIDENTS_ALL_B inc
458: , JTF_TASKS_B tk
459: , JTF_TASK_ASSIGNMENTS ta
460: , CS_INCIDENT_STATUSES_B ists
461: , JTF_TASK_TYPES_B tt
462: , JTF_TASK_STATUSES_B tkst
463: , JTF_TASK_STATUSES_B tast
701: , acc.RESOURCE_ID
702: FROM CSL_CS_INCIDENTS_ALL_ACC acc
703: , CS_INCIDENTS_ALL_B inc
704: , JTF_TASKS_B tsk
705: , JTF_TASK_ASSIGNMENTS ta
706: WHERE tsk.SOURCE_OBJECT_ID = inc.INCIDENT_ID
707: AND tsk.SOURCE_OBJECT_TYPE_CODE = 'SR'
708: AND tsk.TASK_ID = ta.TASK_ID
709: AND ta.RESOURCE_ID = acc.RESOURCE_ID