APPS.CS_ASSIGN_RESOURCE_CON_PKG dependencies on CS_INCIDENTS_ALL_B

Line 97: FROM cs_incidents_all_b

93: coverage_type,sr_creation_channel,cp_component_id, cp_subcomponent_id,
94: inv_component_id, inv_subcomponent_id, incident_country, incident_city,
95: incident_postal_code, incident_state, incident_province, incident_county,
96: incident_location_type
97: FROM cs_incidents_all_b
98: WHERE incident_status_id IN (SELECT incident_status_id
99: FROM cs_incident_statuses
100: WHERE NVL(close_flag,'N') <> 'Y' AND incident_subtype = 'INC')
101: AND NVL(owner_assigned_flag,'N') <> 'Y'

Line 1446: FROM cs_incidents_all_b

1442: AND rs.skill_level_id = s.skill_level_id;
1443:
1444: CURSOR c_time_last_login(l_resource_id NUMBER) IS
1445: SELECT ROUND(((SYSDATE - nvl( max(owner_assigned_time),to_date('1990-01-01','yyyy-mm-dd'))) *24 * 60),2)
1446: FROM cs_incidents_all_b
1447: WHERE incident_owner_id = l_resource_id;
1448:
1449: -- Commented above and added for Bug# 3562642
1450: CURSOR c_imp_level(p_inc_severity_id NUMBER) IS

Line 1458: FROM cs_incidents_all_b

1454: AND incident_severity_id = p_inc_severity_id;
1455:
1456: CURSOR c_sev1_cnt(l_sev1_id NUMBER,l_resource_id NUMBER) IS
1457: SELECT COUNT(*)
1458: FROM cs_incidents_all_b
1459: WHERE incident_severity_id = l_sev1_id
1460: AND incident_owner_id = l_resource_id
1461: AND incident_status_id NOT IN (
1462: SELECT incident_status_id

Line 1469: FROM cs_incidents_all_b

1465: AND close_flag = 'Y');
1466:
1467: CURSOR c_sev2_cnt(l_sev2_id NUMBER ,l_resource_id NUMBER) IS
1468: SELECT COUNT(*)
1469: FROM cs_incidents_all_b
1470: WHERE incident_severity_id = l_sev2_id
1471: AND incident_owner_id = l_resource_id
1472: AND incident_status_id NOT IN (
1473: SELECT incident_status_id

Line 1480: FROM cs_incidents_all_b

1476: AND close_flag = 'Y');
1477:
1478: CURSOR c_sev3_cnt(l_sev3_id NUMBER,l_resource_id NUMBER) IS
1479: SELECT COUNT(*)
1480: FROM cs_incidents_all_b
1481: WHERE incident_severity_id = l_sev3_id
1482: AND incident_owner_id = l_resource_id
1483: AND incident_status_id NOT IN (
1484: SELECT incident_status_id

Line 1491: FROM cs_incidents_all_b

1487: AND close_flag = 'Y');
1488:
1489: CURSOR c_sev4_cnt(l_sev4_id NUMBER,l_resource_id NUMBER) IS
1490: SELECT COUNT(*)
1491: FROM cs_incidents_all_b
1492: WHERE incident_severity_id = l_sev4_id
1493: AND incident_owner_id = l_resource_id
1494: AND incident_status_id NOT IN (
1495: SELECT incident_status_id