APPS.CS_SR_TASK_AUTOASSIGN_PKG dependencies on CS_INCIDENTS_ALL_B

Line 166: FROM cs_incidents_all_b

162: cp_component_id,
163: cp_subcomponent_id,
164: inv_component_id,
165: inv_subcomponent_id
166: FROM cs_incidents_all_b
167: WHERE incident_id = p_incident_id;
168:
169: -- For 11.5.10+ Need to get the location_id from party sites
170: -- for location_type, HZ_PARTY_SITES

Line 216: -- territory attributes from cs_incidents_all_b

212: l_main_return_status := FND_API.G_RET_STS_SUCCESS;
213: -- Raise Error when both incident_id and the service request record is not
214: -- passed. The service request record is checked for null based on the
215: -- incident_type_id. If only incident_id is passed then fetch all the
216: -- territory attributes from cs_incidents_all_b
217: IF (p_incident_id IS NULL and p_service_request_rec.type_id IS NULL) THEN
218: RAISE FND_API.G_EXC_ERROR;
219: ELSE
220: IF (p_service_request_rec.type_id IS NULL) THEN

Line 653: cs_incidents_all_b csi

649:
650: CURSOR c_area_code(c_incident_id NUMBER) IS
651: SELECT hzp.phone_area_code
652: FROM hz_contact_points hzp,
653: cs_incidents_all_b csi
654: WHERE csi.incident_id = c_incident_id
655: AND csi.customer_phone_id = hzp.contact_point_id
656: AND csi.customer_phone_id IS NOT NULL;
657: