APPS.AHL_UMP_UTIL_PKG dependencies on AHL_UNIT_CONFIG_HEADERS

Line 25: FROM ahl_unit_config_headers uc

21:
22: -- Get unit name for component.
23: CURSOR get_unit_name_csr (p_csi_item_instance_id IN NUMBER) IS
24: SELECT name
25: FROM ahl_unit_config_headers uc
26: WHERE csi_item_instance_id in ( SELECT object_id
27: FROM csi_ii_relationships
28: START WITH subject_id = p_csi_item_instance_id
29: AND relationship_type_code = 'COMPONENT-OF'

Line 44: FROM ahl_unit_config_headers uc

40:
41: -- For top node.
42: CURSOR get_unit_name_csr1 (p_csi_item_instance_id IN NUMBER) IS
43: SELECT name
44: FROM ahl_unit_config_headers uc
45: WHERE csi_item_instance_id = p_csi_item_instance_id
46: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
47: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
48: AND parent_uc_header_id IS NULL;

Line 50: l_name ahl_unit_config_headers.name%TYPE;

46: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
47: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
48: AND parent_uc_header_id IS NULL;
49:
50: l_name ahl_unit_config_headers.name%TYPE;
51:
52: begin
53:
54: --Check for top node.