APPS.CUG_GENERIC_WF_PKG dependencies on CS_INCIDENTS_ALL_B

Line 51: FROM cs_incidents_all_b

47:
48: CURSOR l_ServiceRequest_csr IS
49: SELECT incident_location_id, incident_address, incident_city, incident_state,
50: incident_postal_code, incident_country
51: FROM cs_incidents_all_b
52: WHERE incident_id = l_request_id;
53: l_ServiceRequest_rec l_ServiceRequest_csr%ROWTYPE;
54:
55: CURSOR l_IncidentAddress_csr IS

Line 87: SELECT incident_type_id into l_incident_type_id FROM CS_INCIDENTS_ALL_B WHERE

83:
84: OPEN l_CheckIfSRAttrPresent_csr;
85: FETCH l_CheckIfSRAttrPresent_csr INTO l_CheckIfSRAttrPresent_rec;
86: IF (l_CheckIfSRAttrPresent_csr%NOTFOUND) THEN
87: SELECT incident_type_id into l_incident_type_id FROM CS_INCIDENTS_ALL_B WHERE
88: incident_id = l_request_id;
89:
90: l_result := 'Y';
91: OPEN l_CheckIfSRHdrInfoPresent_csr;

Line 239: cs_incidents_all_b where

235:
236: /* begin - to fix bug # 2576759 - added the following cursors and variables */
237: CURSOR l_GetResourceInfo_csr IS
238: select incident_owner_id, owner_group_id, org_id from
239: cs_incidents_all_b where
240: incident_id = l_request_id;
241: l_GetResourceInfo_rec l_GetResourceInfo_csr%ROWTYPE;
242:
243: CURSOR l_GetSourceId_csr IS

Line 589: FROM cs_incidents_all_b

585:
586: CURSOR l_ServiceRequest_csr IS
587: SELECT incident_location_id, incident_address, incident_city, incident_state,
588: incident_postal_code, incident_country
589: FROM cs_incidents_all_b
590: WHERE incident_id = l_request_id;
591: l_ServiceRequest_rec l_ServiceRequest_csr%ROWTYPE;
592:
593: CURSOR l_IncidentAddress_csr IS

Line 1416: SELECT incident_type_id into l_request_type_id from CS_INCIDENTS_ALL_B where incident_id = l_request_id;

1412: l_request_id := WF_Engine.GetItemAttrNumber(itemtype => itemtype,
1413: itemkey => itemkey,
1414: aname => 'REQUEST_ID');
1415:
1416: SELECT incident_type_id into l_request_type_id from CS_INCIDENTS_ALL_B where incident_id = l_request_id;
1417:
1418: l_tasks_pending := 0;
1419:
1420: OPEN c_SRTasks_csr;