[Home] [Help]
1560: cir.subject_id,
1561: --cir.position_reference,
1562: cir.depth
1563: FROM ahl_mr_headers_app_v MR, ahl_mc_path_positions mcp,
1564: --ahl_mc_headers_b hdr, ahl_mc_relationships rel,
1565: cir, ahl_mr_effectivities A
1566: WHERE A.mr_header_id = NVL(c_mr_header_id, A.mr_header_id)
1567: AND MR.mr_header_id = A.mr_header_id
1568: AND MR.mr_status_code = 'COMPLETE'
1902: cir.subject_id,
1903: --cir.position_reference,
1904: cir.depth
1905: FROM ahl_mr_headers_app_v MR, ahl_mr_visit_types vis, ahl_mc_path_positions mcp,
1906: --ahl_mc_headers_b hdr, ahl_mc_relationships rel,
1907: cir, ahl_mr_effectivities A
1908: WHERE MR.mr_header_id = A.mr_header_id
1909: AND A.mr_header_id = vis.mr_header_id
1910: AND vis.mr_visit_type_code = c_visit_type_code
3265:
3266: --Fetches lowest level info
3267: CURSOR get_last_uc_rec_csr(c_csi_instance_id IN NUMBER) IS
3268: SELECT hdr.mc_id, hdr.version_number, rel.position_key
3269: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel, csi_ii_relationships csi_ii
3270: WHERE csi_ii.subject_id = c_csi_instance_id
3271: AND CSI_II.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
3272: AND TRUNC(nvl(CSI_II.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
3273: AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
3301: WHERE up.csi_instance_id = c_csi_instance_id;
3302:
3303: CURSOR get_top_unit_inst_csr (c_csi_instance_id IN NUMBER) IS
3304: SELECT hdr.mc_id, hdr.version_number, rel.position_key
3305: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel, ahl_unit_config_headers uch
3306: WHERE uch.csi_item_instance_id = c_csi_instance_id
3307: AND TRUNC(nvl(uch.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
3308: AND TRUNC(nvl(uch.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
3309: AND hdr.mc_header_id = uch.master_config_id