[Home] [Help]
1300: cir.subject_id,
1301: --cir.position_reference,
1302: cir.depth
1303: FROM ahl_mr_headers_app_v MR, ahl_mc_path_positions mcp,
1304: --ahl_mc_headers_b hdr, ahl_mc_relationships rel,
1305: cir, ahl_mr_effectivities A
1306: WHERE A.mr_header_id = NVL(c_mr_header_id, A.mr_header_id)
1307: AND MR.mr_header_id = A.mr_header_id
1308: AND MR.mr_status_code = 'COMPLETE'
1512: cir.subject_id,
1513: --cir.position_reference,
1514: cir.depth
1515: FROM ahl_mr_headers_app_v MR, ahl_mr_visit_types vis, ahl_mc_path_positions mcp,
1516: --ahl_mc_headers_b hdr, ahl_mc_relationships rel,
1517: cir, ahl_mr_effectivities A
1518: WHERE MR.mr_header_id = A.mr_header_id
1519: AND A.mr_header_id = vis.mr_header_id
1520: AND vis.mr_visit_type_code = c_visit_type_code
2522:
2523: --Fetches lowest level info
2524: CURSOR get_last_uc_rec_csr(c_csi_instance_id IN NUMBER) IS
2525: SELECT hdr.mc_id, hdr.version_number, rel.position_key
2526: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel, csi_ii_relationships csi_ii
2527: WHERE csi_ii.subject_id = c_csi_instance_id
2528: AND CSI_II.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
2529: AND TRUNC(nvl(CSI_II.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
2530: AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
2558: WHERE up.csi_instance_id = c_csi_instance_id;
2559:
2560: CURSOR get_top_unit_inst_csr (c_csi_instance_id IN NUMBER) IS
2561: SELECT hdr.mc_id, hdr.version_number, rel.position_key
2562: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel, ahl_unit_config_headers uch
2563: WHERE uch.csi_item_instance_id = c_csi_instance_id
2564: AND TRUNC(nvl(uch.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
2565: AND TRUNC(nvl(uch.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
2566: AND hdr.mc_header_id = uch.master_config_id