157: , TB.PLANNED_START_DATE
158: , ib.system_id
159: , ib.cust_pref_lang_code
160: FROM jtf_tasks_b tb
161: , cs_incidents_all_b ib
162: , cs_incidents_all_tl it
163: , hz_locations lo
164: , hz_parties pa
165: WHERE tb.task_id = p_task_id
158: , ib.system_id
159: , ib.cust_pref_lang_code
160: FROM jtf_tasks_b tb
161: , cs_incidents_all_b ib
162: , cs_incidents_all_tl it
163: , hz_locations lo
164: , hz_parties pa
165: WHERE tb.task_id = p_task_id
166: AND tb.source_object_type_code = 'SR'
1306:
1307: --Introduced by lokumar for bug#7340932
1308: CURSOR c_business_process IS
1309: select iv.business_process_id
1310: from jtf_tasks_b t, cs_incidents_all i, cs_incident_types_vl iv
1311: where t.task_id = p_task_id
1312: and t.source_object_id = i.incident_id
1313: and i.incident_type_id = iv.incident_type_id;
1314: