APPS.AHL_UTILITY_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 625: FROM ahl_unit_config_headers

621: CURSOR get_uc_instance_id IS
622: SELECT object_id
623: FROM csi_ii_relationships
624: WHERE object_id IN (SELECT csi_item_instance_id
625: FROM ahl_unit_config_headers
626: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
627: START WITH subject_id = p_instance_id
628: AND relationship_type_code = 'COMPONENT-OF'
629: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)

Line 638: FROM ahl_unit_config_headers

634: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
635:
636: CURSOR get_uc_header_name(c_instance_id NUMBER) IS
637: SELECT name
638: FROM ahl_unit_config_headers
639: WHERE csi_item_instance_id = c_instance_id
640: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
641:
642: BEGIN