APPS.CSF_DEBRIEF_PVT dependencies on CS_INCIDENTS_ALL

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

37: l_date_val varchar2(30) := nvl(fnd_profile.value('CSF_DEBRIEF_SERVICE_DATE'),'B');
38:
39: Cursor get_service_request_date IS
40: select nvl(incident_occurred_date,incident_date)
41: from jtf_task_assignments jta , cs_incidents_all cia, jtf_tasks_b jtb,
42: csf_debrief_headers cdh
43: where jta.task_assignment_id = cdh.task_assignment_id
44: and jtb.task_id = jta.task_id
45: and cia.incident_id = jtb.source_object_id

Line 3172: from cs_incidents_all_b

3168: l_customer_product_id number;
3169:
3170: cursor c_customer_product is
3171: select customer_product_id
3172: from cs_incidents_all_b
3173: where incident_id = p_incident_id;
3174:
3175: cursor c_counter is
3176: select max(ccv.value_timestamp),

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

4253: l_service_request_date date;
4254:
4255: Cursor get_service_request_date IS
4256: select nvl(incident_occurred_date,incident_date)
4257: from jtf_task_assignments jta , cs_incidents_all cia, jtf_tasks_b jtb
4258: where jta.task_assignment_id = p_task_assignment_id
4259: and jtb.task_id = jta.task_id
4260: and cia.incident_id = jtb.source_object_id
4261: and jtb.source_object_type_code = 'SR';