APPS.CSFW_SERVICEREQUEST_PUB dependencies on CS_INCIDENTS_ALL_VL

Line 65: select object_version_number from cs_incidents_all_vl where incident_id = v_incident_id;

61: l_msg varchar2(250);
62: r_msg varchar2(250);
63:
64: cursor c_version(v_incident_id number) is
65: select object_version_number from cs_incidents_all_vl where incident_id = v_incident_id;
66:
67: cursor c_incident_type_id (v_incident_id number) is
68: select INCIDENT_TYPE_ID,
69: incident_number,

Line 577: select object_version_number from cs_incidents_all_vl where incident_id = v_incident_id;

573: l_type_id number;
574: L_LAST_UPDATE_PROGRAM_CODE VARCHAR2(30);
575:
576: cursor c_version(v_incident_id number) is
577: select object_version_number from cs_incidents_all_vl where incident_id = v_incident_id;
578:
579: cursor c_incident_type_id (v_incident_id number) is
580: select INCIDENT_TYPE_ID,
581: incident_number,