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 744: FROM cs_incidents_all_b

740: -- 12.1.2 Enhancement
741: Begin
742: SELECT to_char(sysdate, 'd'), to_char(sysdate, 'hh24:mi')
743: INTO l_day_week, l_time_day
744: FROM cs_incidents_all_b
745: WHERE incident_id = l_incident_id ;
746: Exception
747: When Others then
748: l_time_day := null ;

Line 1180: FROM cs_incidents_all_b

1176: -- 12.1.2 Enhancement
1177: Begin
1178: SELECT to_char(sysdate, 'd'), to_char(sysdate, 'hh24:mi')
1179: INTO l_day_week, l_time_day
1180: FROM cs_incidents_all_b
1181: WHERE incident_id = l_incident_id ;
1182: Exception
1183: When Others then
1184: l_time_day := null ;

Line 1539: FROM cs_incidents_all_b

1535: AND rs.skill_level_id = s.skill_level_id;
1536:
1537: CURSOR c_time_last_login(l_resource_id NUMBER) IS
1538: SELECT ROUND(((SYSDATE - nvl( max(owner_assigned_time),to_date('1990-01-01','yyyy-mm-dd'))) *24 * 60),2)
1539: FROM cs_incidents_all_b
1540: WHERE incident_owner_id = l_resource_id;
1541:
1542: -- Commented above and added for Bug# 3562642
1543: CURSOR c_imp_level(p_inc_severity_id NUMBER) IS

Line 1551: FROM cs_incidents_all_b

1547: AND incident_severity_id = p_inc_severity_id;
1548:
1549: CURSOR c_sev1_cnt(l_sev1_id NUMBER,l_resource_id NUMBER) IS
1550: SELECT COUNT(*)
1551: FROM cs_incidents_all_b
1552: WHERE incident_severity_id = l_sev1_id
1553: AND incident_owner_id = l_resource_id
1554: AND incident_status_id NOT IN (
1555: SELECT incident_status_id

Line 1562: FROM cs_incidents_all_b

1558: AND close_flag = 'Y');
1559:
1560: CURSOR c_sev2_cnt(l_sev2_id NUMBER ,l_resource_id NUMBER) IS
1561: SELECT COUNT(*)
1562: FROM cs_incidents_all_b
1563: WHERE incident_severity_id = l_sev2_id
1564: AND incident_owner_id = l_resource_id
1565: AND incident_status_id NOT IN (
1566: SELECT incident_status_id

Line 1573: FROM cs_incidents_all_b

1569: AND close_flag = 'Y');
1570:
1571: CURSOR c_sev3_cnt(l_sev3_id NUMBER,l_resource_id NUMBER) IS
1572: SELECT COUNT(*)
1573: FROM cs_incidents_all_b
1574: WHERE incident_severity_id = l_sev3_id
1575: AND incident_owner_id = l_resource_id
1576: AND incident_status_id NOT IN (
1577: SELECT incident_status_id

Line 1584: FROM cs_incidents_all_b

1580: AND close_flag = 'Y');
1581:
1582: CURSOR c_sev4_cnt(l_sev4_id NUMBER,l_resource_id NUMBER) IS
1583: SELECT COUNT(*)
1584: FROM cs_incidents_all_b
1585: WHERE incident_severity_id = l_sev4_id
1586: AND incident_owner_id = l_resource_id
1587: AND incident_status_id NOT IN (
1588: SELECT incident_status_id