DBA Data[Home] [Help]

APPS.CSM_SERVICE_HISTORY_EVENT_PKG dependencies on JTF_TASK_TYPES_B

Line 36: , JTF_TASK_TYPES_B tt

32: CURSOR c_closed_assignments( b_incident_id NUMBER ) IS
33: SELECT TASK_ASSIGNMENT_ID
34: FROM JTF_TASKS_B tk
35: , JTF_TASK_ASSIGNMENTS ta
36: , JTF_TASK_TYPES_B tt
37: , JTF_TASK_STATUSES_B tkst
38: , JTF_TASK_STATUSES_B tast
39: WHERE tk.SOURCE_OBJECT_ID = b_incident_id
40: AND tk.SOURCE_OBJECT_TYPE_CODE = 'SR'

Line 101: , JTF_TASK_TYPES_B tt

97: b_user_id IN number) IS
98: SELECT TASK_ASSIGNMENT_ID
99: FROM JTF_TASKS_B tk
100: , JTF_TASK_ASSIGNMENTS ta
101: , JTF_TASK_TYPES_B tt
102: , JTF_TASK_STATUSES_B tkst
103: , JTF_TASK_STATUSES_B tast
104: WHERE tk.SOURCE_OBJECT_ID = b_hist_incident_id
105: AND tk.SOURCE_OBJECT_TYPE_CODE = 'SR'

Line 203: , JTF_TASK_TYPES_B tt

199: FROM CS_INCIDENTS_ALL_B inc
200: , JTF_TASKS_B tk
201: , JTF_TASK_ASSIGNMENTS ta
202: , CS_INCIDENT_STATUSES_B ists
203: , JTF_TASK_TYPES_B tt
204: , JTF_TASK_STATUSES_B tkst
205: , JTF_TASK_STATUSES_B tast
206: WHERE inc.CLOSE_DATE <= b_max_date
207: AND inc.INCIDENT_ID = tk.SOURCE_OBJECT_ID

Line 237: , JTF_TASK_TYPES_B tt

233: FROM CS_INCIDENTS_ALL_B inc
234: , JTF_TASKS_B tk
235: , JTF_TASK_ASSIGNMENTS ta
236: , CS_INCIDENT_STATUSES_B ists
237: , JTF_TASK_TYPES_B tt
238: , JTF_TASK_STATUSES_B tkst
239: , JTF_TASK_STATUSES_B tast
240: WHERE inc.CLOSE_DATE <= b_max_date
241: AND inc.INCIDENT_ID = tk.SOURCE_OBJECT_ID