APPS.AHL_PRD_UTIL_PKG dependencies on AHL_VISITS_B

Line 258: ahl_visits_b vst,

254: vst.item_instance_id,
255: vtk.instance_id
256: FROM
257: ahl_visit_tasks_b vtk,
258: ahl_visits_b vst,
259: ahl_workorders wo
260: WHERE
261: wo.workorder_id = p_workorder_id AND
262: vtk.visit_task_id = wo.visit_task_id AND

Line 570: AHL_VISITS_B VST,

566: QPT.PLAN_TRANSACTION_ID = QPCT.PLAN_TRANSACTION_ID AND
567: QP.ORGANIZATION_ID = (SELECT
568: ORGANIZATION_ID
569: FROM
570: AHL_VISITS_B VST,
571: AHL_VISIT_TASKS_B TSK
572: WHERE VST.VISIT_ID = TSK.VISIT_ID AND
573: TSK.UNIT_EFFECTIVITY_ID = p_ue_id AND
574: ROWNUM < 2) AND

Line 681: AHL_VISITS_B VST,

677: SELECT AWOS.STATUS_CODE,
678: NVL(VTS.INSTANCE_ID, VST.ITEM_INSTANCE_ID)
679: FROM
680: AHL_WORKORDERS AWOS,
681: AHL_VISITS_B VST,
682: AHL_VISIT_TASKS_B VTS
683: WHERE
684: AWOS.VISIT_TASK_ID = VTS.VISIT_TASK_ID AND
685: VST.VISIT_ID = VTS.VISIT_ID AND