APPS.AHL_PRD_NONROUTINE_PUB dependencies on CS_INCIDENT_STATUSES_B

Line 652: FROM cs_incidents_all_b CS,CS_INCIDENT_STATUSES_B sts

648:
649: BEGIN
650: SELECT sts.status_code,sts.name
651: INTO x_create_nr_output_rec.service_request_status_code,x_create_nr_output_rec.service_request_status
652: FROM cs_incidents_all_b CS,CS_INCIDENT_STATUSES_B sts
653: WHERE cs.incident_id = p_nr_task_rec.INCIDENT_ID
654: AND sts.INCIDENT_STATUS_ID = cs.incident_Status_id;
655: EXCEPTION
656: WHEN OTHERS THEN

Line 828: FROM CS_INCIDENT_STATUSES_B

824: END IF;
825: BEGIN
826: SELECT status_code
827: INTO x_create_nr_output_rec.SERVICE_REQUEST_STATUS_CODE
828: FROM CS_INCIDENT_STATUSES_B
829: WHERE INCIDENT_STATUS_ID = p_sr_task_rec.Status_id;
830: EXCEPTION
831: WHEN OTHERS THEN
832: NULL;