APPS.AHL_UC_UTILIZATION_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 421: FROM ahl_unit_config_headers

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:

Line 440: l_config_status ahl_unit_config_headers.unit_config_status_code%TYPE;

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:

Line 445: l_unit_config_name ahl_unit_config_headers.name%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:
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: