APPS.AHL_MC_PATH_POSITION_PVT dependencies on CSI_UNIT_INSTANCES_V

Line 477: ahl_unit_config_headers uch, csi_unit_instances_v csi_u

473: --
474: CURSOR get_top_unit_inst_csr (p_csi_instance_id IN NUMBER) IS
475: SELECT hdr.mc_id, hdr.version_number, rel.position_key
476: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel,
477: ahl_unit_config_headers uch, csi_unit_instances_v csi_u
478: WHERE uch.csi_item_instance_id = p_csi_instance_id
479: AND TRUNC(nvl(uch.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
480: AND TRUNC(nvl(uch.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
481: AND hdr.mc_header_id = uch.master_config_id

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

2439: AND TO_NUMBER(CSI_II.POSITION_REFERENCE) = REL.RELATIONSHIP_ID
2440: AND REL.mc_header_id = HDR.mc_header_id;
2441: --
2442: -- Changed by jaramana on July 13, 2006 to fix FP of bug 5368714
2443: -- Do not join with csi_unit_instances_v for filtering out non top level nodes
2444: -- since it does not take dates into consideration
2445: /*
2446: CURSOR get_top_unit_inst_csr (p_csi_instance_id IN NUMBER) IS
2447: SELECT hdr.mc_id, hdr.version_number, rel.position_key

Line 2449: ahl_unit_config_headers uch, csi_unit_instances_v csi_u

2445: /*
2446: CURSOR get_top_unit_inst_csr (p_csi_instance_id IN NUMBER) IS
2447: SELECT hdr.mc_id, hdr.version_number, rel.position_key
2448: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel,
2449: ahl_unit_config_headers uch, csi_unit_instances_v csi_u
2450: WHERE uch.csi_item_instance_id = p_csi_instance_id
2451: AND TRUNC(nvl(uch.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
2452: AND TRUNC(nvl(uch.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
2453: AND hdr.mc_header_id = uch.master_config_id