APPS.CSF_DEBRIEF_PVT dependencies on CS_INCIDENTS_ALL

Line 32: from jtf_task_assignments jta , cs_incidents_all cia, jtf_tasks_b jtb,

28: l_service_request_date date;
29:
30: Cursor get_service_request_date IS
31: select nvl(incident_occurred_date,incident_date)
32: from jtf_task_assignments jta , cs_incidents_all cia, jtf_tasks_b jtb,
33: csf_debrief_headers cdh
34: where jta.task_assignment_id = cdh.task_assignment_id
35: and jtb.task_id = jta.task_id
36: and cia.incident_id = jtb.source_object_id

Line 3102: from cs_incidents_all_b ci_all,

3098: l_count number;
3099: l_count2 number;
3100: cursor c_counter is
3101: select count(*) --cs_ctr.name, cs_ctr_v.value_timestamp
3102: from cs_incidents_all_b ci_all,
3103: cs_counter_groups cs_grp,
3104: cs_counters cs_ctr,
3105: cs_counter_values cs_ctr_v,
3106: jtf_tasks_b jt_b

Line 3118: cs_incidents_all_b ci_all,

3114: and nvl(cs_ctr_v.value_timestamp,jt_b.creation_date - 1) < least(jt_b.creation_date,sysdate); -- changed for bug 3558815
3115:
3116: cursor c_counter2 is
3117: Select count(*) from
3118: cs_incidents_all_b ci_all,
3119: cs_counter_groups cs_grp,
3120: cs_counters cs_ctr,
3121: cs_counter_values cs_ctr_v,
3122: jtf_tasks_b jt_b

Line 3813: from jtf_task_assignments jta , cs_incidents_all cia, jtf_tasks_b jtb

3809: l_service_request_date date;
3810:
3811: Cursor get_service_request_date IS
3812: select nvl(incident_occurred_date,incident_date)
3813: from jtf_task_assignments jta , cs_incidents_all cia, jtf_tasks_b jtb
3814: where jta.task_assignment_id = p_task_assignment_id
3815: and jtb.task_id = jta.task_id
3816: and cia.incident_id = jtb.source_object_id
3817: and jtb.source_object_type_code = 'SR';