DBA Data[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on CS_INCIDENTS_AUDIT_B

Line 3106: FROM cs_incidents_audit_b

3102: -- Cursor to get the target status using SR audit.
3103:
3104: CURSOR c_get_initial_status IS
3105: SELECT old_incident_status_id
3106: FROM cs_incidents_audit_b
3107: WHERE rowid = ( SELECT max(rowid)
3108: FROM cs_incidents_audit_b
3109: WHERE incident_id = p_incident_id
3110: AND incident_status_id = p_intermediate_status_id

Line 3108: FROM cs_incidents_audit_b

3104: CURSOR c_get_initial_status IS
3105: SELECT old_incident_status_id
3106: FROM cs_incidents_audit_b
3107: WHERE rowid = ( SELECT max(rowid)
3108: FROM cs_incidents_audit_b
3109: WHERE incident_id = p_incident_id
3110: AND incident_status_id = p_intermediate_status_id
3111: AND old_incident_status_id <> p_intermediate_status_id
3112: GROUP BY incident_id , incident_status_id);