APPS.AHL_PRD_NONROUTINE_PUB dependencies on AHL_VISITS_B

Line 351: ahl_visits_b vst,

347: BEGIN
348: SELECT csi.instance_number,vst.visit_number
349: INTO x_sr_task_rec.instance_number,x_sr_task_rec.visit_number
350: FROM ahl_workorders wo,
351: ahl_visits_b vst,
352: ahl_visit_tasks_b tsk,
353: csi_item_instances csi
354: WHERE wo.visit_task_id = tsk.visit_task_id
355: AND vst.visit_id = tsk.visit_id

Line 378: AHL_VISITS_B VST,

374: BEGIN
375: SELECT CSI.INSTANCE_NUMBER,VST.visit_number,WO.workorder_id
376: INTO x_sr_task_rec.instance_number,x_sr_task_rec.visit_number,x_sr_task_rec.Originating_wo_id
377: FROM AHL_WORKORDERS WO,
378: AHL_VISITS_B VST,
379: AHL_VISIT_TASKS_B TSK,
380: CSI_ITEM_INSTANCES CSI
381: WHERE WO.VISIT_TASK_ID = TSK.VISIT_TASK_ID
382: AND VST.VISIT_ID = TSK.VISIT_ID

Line 789: ahl_visits_b vst

785: x_create_nr_output_rec.ORIGINATOR_VISIT_ID,
786: x_create_nr_output_rec.ORIGINATOR_VISIT_NUMBER,
787: x_create_nr_output_rec.ORIGINATOR_TASK
788: FROM ahl_workorders,
789: ahl_visits_b vst
790: WHERE workorder_id = p_sr_task_rec.ORIGINATING_WO_ID
791: AND vst.visit_id = ahl_workorders.visit_id(+);
792: EXCEPTION
793: WHEN OTHERS THEN