DBA Data[Home] [Help]

APPS.EAM_SRAPPROVAL_PVT dependencies on CS_INCIDENTS_VL_SEC

Line 84: from cs_incidents_vl_sec cia, cs_incident_types_vl_sec cit

80: l_incident_id,l_owning_department_id,l_inventory_item_id
81: ,l_maint_organization_id, l_incident_date, l_expected_resolution_date,l_maintenance_flag
82: ,l_incident_status_id,l_incident_severity_id,l_customer_id,l_object_version_number
83: ,l_instance_id
84: from cs_incidents_vl_sec cia, cs_incident_types_vl_sec cit
85: where cia.incident_number = l_incident_number
86: and cia.incident_type_id = cit.incident_type_id;
87: exception
88: when others then

Line 367: from cs_incidents_vl_sec cia, cs_incident_types_vl_sec cit

363: into
364: l_incident_id,l_owning_department_id,l_inventory_item_id,l_maint_organization_id
365: ,l_incident_date, l_expected_resolution_date,l_maintenance_flag
366: ,l_instance_id
367: from cs_incidents_vl_sec cia, cs_incident_types_vl_sec cit
368: where cia.incident_number = l_incident_number
369: and cia.incident_type_id = cit.incident_type_id;
370:
371: -- if service request type is maintenance, then proceed else terminate