DBA Data[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on CS_INCIDENTS_AUDIT_B

Line 3012: FROM cs_incidents_audit_b

3008: -- Cursor to get the target status using SR audit.
3009:
3010: CURSOR c_get_initial_status IS
3011: SELECT old_incident_status_id
3012: FROM cs_incidents_audit_b
3013: WHERE rowid = ( SELECT max(rowid)
3014: FROM cs_incidents_audit_b
3015: WHERE incident_id = p_incident_id
3016: AND incident_status_id = p_intermediate_status_id

Line 3014: FROM cs_incidents_audit_b

3010: CURSOR c_get_initial_status IS
3011: SELECT old_incident_status_id
3012: FROM cs_incidents_audit_b
3013: WHERE rowid = ( SELECT max(rowid)
3014: FROM cs_incidents_audit_b
3015: WHERE incident_id = p_incident_id
3016: AND incident_status_id = p_intermediate_status_id
3017: AND old_incident_status_id <> p_intermediate_status_id
3018: GROUP BY incident_id , incident_status_id);