APPS.BIV_SR_DETAILS_PKG dependencies on CS_INCIDENTS_AUDIT_B

Line 30: from cs_incidents_audit_b au1,

26: procedure get_data (errbuf out nocopy varchar2,
27: retcode out nocopy number) is
28: cursor c_reopen_sr is
29: select au1.incident_id,min(au1.last_update_date)
30: from cs_incidents_audit_b au1,
31: cs_incident_statuses_b stat1,
32: cs_incident_statuses_b stat2
33: where au1.change_incident_status_flag = 'Y'
34: and au1.old_incident_status_id = stat1.incident_status_id

Line 117: from cs_incidents_audit_b au2,

113: x_reclose_date in out nocopy date) as
114: begin
115: select min(au2.last_update_date)
116: into x_reclose_date
117: from cs_incidents_audit_b au2,
118: cs_incident_statuses_b stat3,
119: cs_incident_statuses_b stat4
120: where au2.incident_id = p_incident_id
121: and au2.last_update_date > p_reopen_date

Line 249: from cs_incidents_audit_b

245: l_update_date date;
246: begin
247: select min(last_update_date)
248: into l_update_date
249: from cs_incidents_audit_b
250: where incident_id = p_incident_id;
251:
252: if l_update_date is null then return null;
253: else return(l_update_date-p_incident_date);