APPS.AHL_VWP_PLAN_TASKS_PVT dependencies on CS_INCIDENTS_ALL_B

Line 459: l_incident_number CS_INCIDENTS_ALL_B.INCIDENT_NUMBER%TYPE;

455: l_past_task_start_date DATE;
456: l_past_task_end_date DATE;
457:
458: -- AnRaj: changed for Fixing Siberian Airlines Bug#5007335
459: l_incident_number CS_INCIDENTS_ALL_B.INCIDENT_NUMBER%TYPE;
460: l_object_version_number CS_INCIDENTS_ALL_B.OBJECT_VERSION_NUMBER%TYPE;
461: l_incident_status_id CS_INCIDENTS_ALL_B.INCIDENT_ID%TYPE;
462: -- End Of Fix Bug#5007335
463:

Line 460: l_object_version_number CS_INCIDENTS_ALL_B.OBJECT_VERSION_NUMBER%TYPE;

456: l_past_task_end_date DATE;
457:
458: -- AnRaj: changed for Fixing Siberian Airlines Bug#5007335
459: l_incident_number CS_INCIDENTS_ALL_B.INCIDENT_NUMBER%TYPE;
460: l_object_version_number CS_INCIDENTS_ALL_B.OBJECT_VERSION_NUMBER%TYPE;
461: l_incident_status_id CS_INCIDENTS_ALL_B.INCIDENT_ID%TYPE;
462: -- End Of Fix Bug#5007335
463:
464: l_status_name cs_incident_statuses_tl.name%type;

Line 461: l_incident_status_id CS_INCIDENTS_ALL_B.INCIDENT_ID%TYPE;

457:
458: -- AnRaj: changed for Fixing Siberian Airlines Bug#5007335
459: l_incident_number CS_INCIDENTS_ALL_B.INCIDENT_NUMBER%TYPE;
460: l_object_version_number CS_INCIDENTS_ALL_B.OBJECT_VERSION_NUMBER%TYPE;
461: l_incident_status_id CS_INCIDENTS_ALL_B.INCIDENT_ID%TYPE;
462: -- End Of Fix Bug#5007335
463:
464: l_status_name cs_incident_statuses_tl.name%type;
465: l_interaction_id NUMBER;

Line 587: FROM CS_INCIDENTS_ALL_B

583: IS
584: SELECT INCIDENT_ID,
585: INCIDENT_NUMBER,
586: OBJECT_VERSION_NUMBER
587: FROM CS_INCIDENTS_ALL_B
588: WHERE INCIDENT_ID=P_service_id;
589:
590: -- AnRaj:Changed cursor for issues mentioned in bug#5007335
591: CURSOR c_service_status