417: AND trunc(sysdate) < trunc(nvl(ctr.end_date_active,sysdate+1));
418:
419: CURSOR ahl_unit_config_csr (c_instance_id NUMBER) IS
420: SELECT unit_config_header_id
421: FROM ahl_unit_config_headers
422: WHERE csi_item_instance_id = c_instance_id
423: AND trunc(sysdate) >= trunc(nvl(active_start_date,sysdate))
424: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1));
425:
436: l_csi_instance_usage_code CSI_LOOKUPS.lookup_code%TYPE;
437: l_junk VARCHAR2(30);
438: l_return_val BOOLEAN;
439:
440: l_config_status ahl_unit_config_headers.unit_config_status_code%TYPE;
441: l_master_config_status ahl_mc_headers_b.config_status_code%TYPE;
442: l_master_config_name ahl_mc_headers_b.name%TYPE;
443: l_master_config_id NUMBER;
444:
441: l_master_config_status ahl_mc_headers_b.config_status_code%TYPE;
442: l_master_config_name ahl_mc_headers_b.name%TYPE;
443: l_master_config_id NUMBER;
444:
445: l_unit_config_name ahl_unit_config_headers.name%TYPE;
446: l_location_type_code csi_item_instances.location_type_code%TYPE;
447: l_active_end_date DATE;
448: l_active_start_date DATE;
449: