APPS.AHL_PRD_NONROUTINE_PUB dependencies on AHL_VISITS_B

Line 328: ahl_visits_b vst,

324: BEGIN
325: SELECT csi.instance_number,vst.visit_number
326: INTO x_sr_task_rec.instance_number,x_sr_task_rec.visit_number
327: FROM ahl_workorders wo,
328: ahl_visits_b vst,
329: ahl_visit_tasks_b tsk,
330: csi_item_instances csi
331: WHERE wo.visit_task_id = tsk.visit_task_id
332: AND vst.visit_id = tsk.visit_id

Line 355: AHL_VISITS_B VST,

351: BEGIN
352: SELECT CSI.INSTANCE_NUMBER,VST.visit_number,WO.workorder_id
353: INTO x_sr_task_rec.instance_number,x_sr_task_rec.visit_number,x_sr_task_rec.Originating_wo_id
354: FROM AHL_WORKORDERS WO,
355: AHL_VISITS_B VST,
356: AHL_VISIT_TASKS_B TSK,
357: CSI_ITEM_INSTANCES CSI
358: WHERE WO.VISIT_TASK_ID = TSK.VISIT_TASK_ID
359: AND VST.VISIT_ID = TSK.VISIT_ID

Line 786: ahl_visits_b vst

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