APPS.CS_ASSIGN_RESOURCE_PKG dependencies on CS_INCIDENTS_ALL_B

Line 571: FROM cs_incidents_all_b

567: -- 12.1.2 Enhancement
568: Begin
569: SELECT to_char(sysdate, 'd'), to_char(sysdate, 'hh24:mi')
570: INTO l_day_week, l_time_day
571: FROM cs_incidents_all_b
572: WHERE incident_id = l_incident_id ;
573: Exception
574: When Others then
575: l_time_day := null ;

Line 1056: FROM cs_incidents_all_b

1052: -- 12.1.2 Enhancement
1053: Begin
1054: SELECT to_char(sysdate, 'd'), to_char(sysdate, 'hh24:mi')
1055: INTO l_day_week, l_time_day
1056: FROM cs_incidents_all_b
1057: WHERE incident_id = l_incident_id ;
1058: Exception
1059: When Others then
1060: l_time_day := null ;

Line 1472: FROM cs_incidents_all_b

1468:
1469:
1470: CURSOR c_time_last_login(l_resource_id NUMBER) is
1471: SELECT ROUND(((SYSDATE - nvl( max(owner_assigned_time),to_date('1990-01-01','yyyy-mm-dd'))) *24 * 60),2)
1472: FROM cs_incidents_all_b
1473: WHERE incident_owner_id = l_resource_id;
1474:
1475: CURSOR c_imp_level(p_inc_severity_id NUMBER) IS
1476: SELECT importance_level

Line 1483: FROM cs_incidents_all_b

1479: AND incident_severity_id = p_inc_severity_id;
1480:
1481: CURSOR c_sev1_cnt(l_sev1_id NUMBER,l_resource_id NUMBER) IS
1482: SELECT COUNT(*)
1483: FROM cs_incidents_all_b
1484: WHERE incident_severity_id = l_sev1_id
1485: AND incident_owner_id = l_resource_id
1486: AND incident_status_id NOT IN (
1487: SELECT incident_status_id

Line 1494: FROM cs_incidents_all_b

1490: AND close_flag = 'Y');
1491:
1492: CURSOR c_sev2_cnt(l_sev2_id NUMBER ,l_resource_id NUMBER) IS
1493: SELECT COUNT(*)
1494: FROM cs_incidents_all_b
1495: WHERE incident_severity_id = l_sev2_id
1496: AND incident_owner_id = l_resource_id
1497: AND incident_status_id NOT IN (
1498: SELECT incident_status_id

Line 1505: FROM cs_incidents_all_b

1501: AND close_flag = 'Y');
1502:
1503: CURSOR c_sev3_cnt(l_sev3_id NUMBER,l_resource_id NUMBER) IS
1504: SELECT COUNT(*)
1505: FROM cs_incidents_all_b
1506: WHERE incident_severity_id = l_sev3_id
1507: AND incident_owner_id = l_resource_id
1508: AND incident_status_id NOT IN (
1509: select incident_status_id

Line 1516: FROM cs_incidents_all_b

1512: AND close_flag = 'Y');
1513:
1514: CURSOR c_sev4_cnt(l_sev4_id NUMBER,l_resource_id NUMBER) IS
1515: SELECT COUNT(*)
1516: FROM cs_incidents_all_b
1517: WHERE incident_severity_id = l_sev4_id
1518: AND incident_owner_id = l_resource_id
1519: AND incident_status_id NOT IN (
1520: SELECT incident_status_id