APPS.CS_SERVICEREQUEST_UTIL dependencies on CS_INCIDENT_STATUSES_VL

Line 525: FROM cs_incident_statuses_vl

521: x_return_status := FND_API.G_RET_STS_SUCCESS;
522:
523: BEGIN
524: SELECT incident_status_id INTO p_status_id
525: FROM cs_incident_statuses_vl
526: WHERE incident_subtype = p_subtype
527: AND UPPER(name) = UPPER(p_status_name)
528: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
529: AND TRUNC(NVL(end_date_active, SYSDATE))

Line 537: p_table_name => 'CS_INCIDENT_STATUSES_VL',

533: x_return_status := FND_API.G_RET_STS_ERROR;
534: Add_Invalid_Argument_Msg( p_token_an => l_api_name_full,
535: p_token_v => p_status_name,
536: p_token_p => p_parameter_name,
537: p_table_name => 'CS_INCIDENT_STATUSES_VL',
538: p_column_name => 'NAME');
539: WHEN OTHERS THEN
540: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
541: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);

Line 9831: FROM cs_incident_statuses_vl

9827: , resolved_flag
9828: INTO
9829: l_new_responded_flag
9830: , l_new_resolved_flag
9831: FROM cs_incident_statuses_vl
9832: WHERE incident_status_id=p_incident_status_id ;
9833:
9834: SELECT
9835: responded_flag

Line 9840: FROM cs_incident_statuses_vl

9836: , resolved_flag
9837: INTO
9838: l_old_responded_flag
9839: , l_old_resolved_flag
9840: FROM cs_incident_statuses_vl
9841: WHERE incident_status_id=p_old_incident_status_id ;
9842:
9843: IF((l_old_responded_flag <>'Y' OR l_old_responded_flag is NULL) AND
9844: (l_new_responded_flag='Y'))