[Home] [Help]
140: CURSOR check_parent_mr(c_ue_id in NUMBER,
141: c_instance_id in NUMBER,
142: c_visit_id in NUMBER)IS
143: SELECT 'X'
144: FROM ahl_ue_relationships uer, ahl_visit_tasks_b vtk, ahl_unit_effectivities_b uet
145: WHERE uer.ue_id = c_ue_id
146: AND vtk.instance_id = c_instance_id
147: AND vtk.visit_id = c_visit_id
148: AND uer.ue_id = uet.unit_effectivity_id
157: WHERE une.csi_item_instance_id = c_instance_id
158: AND (une.status_code ='INIT-DUE' OR une.status_code IS NULL)
159: AND une.due_date is NOT NULL
160: AND (une.due_date between c_start_date AND c_end_date or (une.earliest_due_date between c_start_date AND c_end_date OR une.latest_due_date between c_start_date AND c_end_date))
161: AND NOT EXISTS (SELECT 'X' FROM ahl_ue_relationships uer WHERE uer.related_ue_id = une.unit_effectivity_id)
162: AND une.mr_header_id = mrh.mr_header_id
163: AND NOT exists (SELECT 'X' FROM ahl_visit_tasks_b task, ahl_visits_b visit
164: WHERE task.visit_id = visit.visit_id AND task.unit_effectivity_id = une.unit_effectivity_id
165: AND task.status_code NOT IN ('CANCELLED', 'DELETED'));
189: AND une.csi_item_instance_id = uch.csi_item_instance_id
190: AND (une.status_code ='INIT-DUE' OR une.status_code IS NULL)
191: AND une.due_date IS NOT NULL
192: AND (une.due_date between c_start_date AND c_end_date or (une.earliest_due_date between c_start_date AND c_end_date OR une.latest_due_date between c_start_date AND c_end_date))
193: AND NOT EXISTS (SELECT 'X' FROM ahl_ue_relationships uer WHERE uer.related_ue_id = une.unit_effectivity_id)
194: AND une.mr_header_id = mrh.mr_header_id
195: AND NOT exists (SELECT 'X' FROM ahl_visit_tasks_b task, ahl_visits_b visit
196: WHERE task.visit_id = visit.visit_id AND task.unit_effectivity_id = une.unit_effectivity_id
197: AND task.status_code NOT IN ('CANCELLED', 'DELETED'));