APPS.BIV_SR_DETAILS_PKG dependencies on CS_INCIDENT_STATUSES_B

Line 31: cs_incident_statuses_b stat1,

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
35: and au1.incident_status_id = stat2.incident_status_id

Line 32: cs_incident_statuses_b stat2

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
35: and au1.incident_status_id = stat2.incident_status_id
36: and nvl(stat1.close_flag,'N') = 'Y'

Line 118: cs_incident_statuses_b stat3,

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
122: and au2.change_incident_status_flag = 'Y'

Line 119: cs_incident_statuses_b stat4

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
122: and au2.change_incident_status_flag = 'Y'
123: and au2.old_incident_status_id = stat3.incident_status_id