APPS.AHL_UMP_PROCESSUNIT_EXTN_PVT dependencies on AHL_VISIT_TASKS_B

Line 559: FROM ahl_unit_effectivities_b ue, ahl_visit_tasks_b vts,

555: BEGIN
556: SELECT due_date, unit_effectivity_id INTO l_min_mr_due_date, l_min_mr_ue_id
557: FROM (
558: SELECT ue.due_date, ue.unit_effectivity_id
559: FROM ahl_unit_effectivities_b ue, ahl_visit_tasks_b vts,
560: ahl_mr_headers_b mr1, ahl_mr_headers_b mr2
561: WHERE ue.csi_item_instance_id = l_temp_mr_rec.csi_item_instance_id
562: AND ue.mr_header_id = mr1.mr_header_id
563: AND mr1.title = mr2.title