APPS.AHL_UMP_UTIL_PKG dependencies on AHL_UNIT_CONFIG_HEADERS

Line 16: FROM ahl_unit_config_headers uc

12:
13: -- Get unit name for component.
14: CURSOR get_unit_name_csr (p_csi_item_instance_id IN NUMBER) IS
15: SELECT name
16: FROM ahl_unit_config_headers uc
17: WHERE csi_item_instance_id in ( SELECT object_id
18: FROM csi_ii_relationships
19: START WITH subject_id = p_csi_item_instance_id
20: AND relationship_type_code = 'COMPONENT-OF'

Line 35: FROM ahl_unit_config_headers uc

31:
32: -- For top node.
33: CURSOR get_unit_name_csr1 (p_csi_item_instance_id IN NUMBER) IS
34: SELECT name
35: FROM ahl_unit_config_headers uc
36: WHERE csi_item_instance_id = p_csi_item_instance_id
37: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
38: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
39: AND parent_uc_header_id IS NULL;

Line 41: l_name ahl_unit_config_headers.name%TYPE;

37: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
38: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
39: AND parent_uc_header_id IS NULL;
40:
41: l_name ahl_unit_config_headers.name%TYPE;
42:
43: begin
44:
45: --Check for top node.