APPS.CSF_DEBRIEF_UPDATE_PKG dependencies on CS_INCIDENTS_ALL

Line 209: cs_incidents_all_b ciab

205: JTF_TASK_STATUSES_B jtsb,
206: CSF_DEBRIEF_HEADERS cdh,
207: JTF_TASKS_B jtb,
208: JTF_TASK_ASSIGNMENTS jta,
209: cs_incidents_all_b ciab
210: WHERE cdh.task_assignment_id = jta.task_assignment_id
211: and jta.task_id = jtb.task_id
212: and nvl(jtb.deleted_flag,'N') <> 'Y'
213: and jta.assignment_status_id = jtsb.task_status_id

Line 264: cs_incidents_all_b ciab

260: JTF_TASK_STATUSES_B jtsb,
261: CSF_DEBRIEF_HEADERS cdh,
262: JTF_TASKS_B jtb,
263: JTF_TASK_ASSIGNMENTS jta,
264: cs_incidents_all_b ciab
265: WHERE cdh.task_assignment_id = jta.task_assignment_id
266: and jta.task_id = jtb.task_id
267: and nvl(jtb.deleted_flag,'N') <> 'Y'
268: and jta.assignment_status_id = jtsb.task_status_id

Line 384: from cs_incidents_all

380:
381: cursor c_site (p_incident_id number) Is
382: select install_site_use_id,
383: ship_to_site_use_id
384: from cs_incidents_all
385: where incident_id = p_incident_id;
386:
387: cursor c_party_site_id (p_install_site_id number) Is
388: select party_site_id