APPS.BIV_SR_DETAILS_PKG dependencies on CS_INCIDENTS_ALL_B

Line 39: l_incident_id cs_incidents_all_b.incident_id % type;

35: and au1.incident_status_id = stat2.incident_status_id
36: and nvl(stat1.close_flag,'N') = 'Y'
37: and nvl(stat2.close_flag,'N') <> 'Y'
38: group by au1.incident_id;
39: l_incident_id cs_incidents_all_b.incident_id % type;
40: l_incident_date date;
41: l_reopen_date date;
42: l_reclose_date date;
43: l_resp_time number;

Line 51: from cs_incidents_all_b

47: l_user_id number := fnd_global.user_id;
48: l_login_id number := fnd_global.login_id;
49: cursor c_sreqs is
50: select incident_id, incident_date
51: from cs_incidents_all_b
52: where last_update_date >= l_last_prog_run;
53: begin
54: l_last_prog_run := get_last_run_time;
55: --dbms_output.put_line('Last time program was run on ' ||

Line 74: from cs_incidents_all_b sr

70: l_curr_time,
71: l_user_id,
72: l_user_id,
73: l_login_id
74: from cs_incidents_all_b sr
75: where not exists ( select 1 from biv_sr_summary sm
76: where sr.incident_id = sm.incident_id)
77: ;
78: --dbms_output.put_line('Number of New incidents inserted in Summary Table :'||

Line 151: l_incident_id cs_incidents_all_b.incident_id % type;

147: where r.object_type_code = 'SR'
148: and r.reference_code = 'ESC'
149: and r.task_id = t.task_id
150: and t.task_type_id = 22;
151: l_incident_id cs_incidents_all_b.incident_id % type;
152: l_esc_level jtf_tasks_b.escalation_level % type;
153: l_owner_type_code jtf_tasks_b.owner_type_code % type;
154: l_owner_id jtf_tasks_b.owner_id % type;
155: l_dt jtf_task_references_b.creation_date % type;