DBA Data[Home] [Help]

APPS.CSFW_SERVICEREQUEST_PUB dependencies on CS_INCIDENTS_ALL_VL

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

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

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

558: l_type_id number;
559: L_LAST_UPDATE_PROGRAM_CODE VARCHAR2(30);
560:
561: cursor c_version(v_incident_id number) is
562: select object_version_number from cs_incidents_all_vl where incident_id = v_incident_id;
563:
564: cursor c_incident_type_id (v_incident_id number) is
565: select INCIDENT_TYPE_ID,
566: incident_number,