DBA Data[Home] [Help]

APPS.CSF_RESOURCE_PUB dependencies on CS_INCIDENTS_ALL

Line 161: , cs_incidents_all_b ib

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

Line 162: , cs_incidents_all_tl it

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'

Line 1310: from jtf_tasks_b t, cs_incidents_all i, cs_incident_types_vl iv

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: