APPS.AHL_MC_PATH_POSITION_PVT dependencies on CSI_UNIT_INSTANCES_V

Line 486: ahl_unit_config_headers uch, csi_unit_instances_v csi_u

482: --
483: CURSOR get_top_unit_inst_csr (p_csi_instance_id IN NUMBER) IS
484: SELECT hdr.mc_id, hdr.version_number, rel.position_key
485: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel,
486: ahl_unit_config_headers uch, csi_unit_instances_v csi_u
487: WHERE uch.csi_item_instance_id = p_csi_instance_id
488: AND TRUNC(nvl(uch.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
489: AND TRUNC(nvl(uch.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
490: AND hdr.mc_header_id = uch.master_config_id

Line 2501: -- Do not join with csi_unit_instances_v for filtering out non top level nodes

2497: AND TO_NUMBER(CSI_II.POSITION_REFERENCE) = REL.RELATIONSHIP_ID
2498: AND REL.mc_header_id = HDR.mc_header_id;
2499: --
2500: -- Changed by jaramana on July 13, 2006 to fix FP of bug 5368714
2501: -- Do not join with csi_unit_instances_v for filtering out non top level nodes
2502: -- since it does not take dates into consideration
2503: /*
2504: CURSOR get_top_unit_inst_csr (p_csi_instance_id IN NUMBER) IS
2505: SELECT hdr.mc_id, hdr.version_number, rel.position_key

Line 2507: ahl_unit_config_headers uch, csi_unit_instances_v csi_u

2503: /*
2504: CURSOR get_top_unit_inst_csr (p_csi_instance_id IN NUMBER) IS
2505: SELECT hdr.mc_id, hdr.version_number, rel.position_key
2506: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel,
2507: ahl_unit_config_headers uch, csi_unit_instances_v csi_u
2508: WHERE uch.csi_item_instance_id = p_csi_instance_id
2509: AND TRUNC(nvl(uch.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
2510: AND TRUNC(nvl(uch.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
2511: AND hdr.mc_header_id = uch.master_config_id