APPS.CSL_SERVICE_HISTORY_PKG dependencies on JTF_TASKS_B

Line 166: FROM JTF_TASKS_B tk

162: , p_resource_id NUMBER )
163: IS
164: CURSOR c_closed_tasks( b_incident_id NUMBER )IS
165: SELECT tk.TASK_ID
166: FROM JTF_TASKS_B tk
167: , JTF_TASK_STATUSES_B ts
168: WHERE tk.SOURCE_OBJECT_TYPE_CODE = 'SR'
169: AND tk.SOURCE_OBJECT_ID = b_incident_id
170: AND tk.TASK_STATUS_ID = ts.TASK_STATUS_ID

Line 250: FROM JTF_TASKS_B tk

246: l_dummy BOOLEAN;
247:
248: CURSOR c_closed_tasks( b_incident_id NUMBER )IS
249: SELECT tk.TASK_ID
250: FROM JTF_TASKS_B tk
251: , JTF_TASK_STATUSES_B ts
252: WHERE tk.SOURCE_OBJECT_TYPE_CODE = 'SR'
253: AND tk.SOURCE_OBJECT_ID = b_incident_id
254: AND tk.TASK_STATUS_ID = ts.TASK_STATUS_ID

Line 409: FROM JTF_TASKS_B tk

405:
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

Line 423: , JTF_TASKS_B tk

419: b_customer_product_id NUMBER ) IS
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

Line 458: , JTF_TASKS_B tk

454: b_incident_location_id NUMBER ) IS
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

Line 704: , JTF_TASKS_B tsk

700: SELECT acc.INCIDENT_ID
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