APPS.AHL_VWP_PLAN_TASKS_PVT dependencies on CS_INCIDENTS_ALL_B

Line 448: l_incident_number CS_INCIDENTS_ALL_B.INCIDENT_NUMBER%TYPE;

444: l_workflow_process_id NUMBER;
445: l_incident_id NUMBER;
446:
447: -- AnRaj: changed for Fixing Siberian Airlines Bug#5007335
448: l_incident_number CS_INCIDENTS_ALL_B.INCIDENT_NUMBER%TYPE;
449: l_object_version_number CS_INCIDENTS_ALL_B.OBJECT_VERSION_NUMBER%TYPE;
450: l_incident_status_id CS_INCIDENTS_ALL_B.INCIDENT_ID%TYPE;
451: -- End Of Fix Bug#5007335
452:

Line 449: l_object_version_number CS_INCIDENTS_ALL_B.OBJECT_VERSION_NUMBER%TYPE;

445: l_incident_id NUMBER;
446:
447: -- AnRaj: changed for Fixing Siberian Airlines Bug#5007335
448: l_incident_number CS_INCIDENTS_ALL_B.INCIDENT_NUMBER%TYPE;
449: l_object_version_number CS_INCIDENTS_ALL_B.OBJECT_VERSION_NUMBER%TYPE;
450: l_incident_status_id CS_INCIDENTS_ALL_B.INCIDENT_ID%TYPE;
451: -- End Of Fix Bug#5007335
452:
453: l_status_name cs_incident_statuses_tl.name%type;

Line 450: l_incident_status_id CS_INCIDENTS_ALL_B.INCIDENT_ID%TYPE;

446:
447: -- AnRaj: changed for Fixing Siberian Airlines Bug#5007335
448: l_incident_number CS_INCIDENTS_ALL_B.INCIDENT_NUMBER%TYPE;
449: l_object_version_number CS_INCIDENTS_ALL_B.OBJECT_VERSION_NUMBER%TYPE;
450: l_incident_status_id CS_INCIDENTS_ALL_B.INCIDENT_ID%TYPE;
451: -- End Of Fix Bug#5007335
452:
453: l_status_name cs_incident_statuses_tl.name%type;
454: l_interaction_id NUMBER;

Line 576: FROM CS_INCIDENTS_ALL_B

572: IS
573: SELECT INCIDENT_ID,
574: INCIDENT_NUMBER,
575: OBJECT_VERSION_NUMBER
576: FROM CS_INCIDENTS_ALL_B
577: WHERE INCIDENT_ID=P_service_id;
578:
579: -- AnRaj:Changed cursor for issues mentioned in bug#5007335
580: CURSOR c_service_status