APPS.AHL_PRD_VISITS_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 116: FROM ahl_unit_config_headers uc

112: -- Define local Cursors
113: -- Get unit name for component.
114: CURSOR get_unit_name_csr (p_csi_item_instance_id IN NUMBER) IS
115: SELECT name
116: FROM ahl_unit_config_headers uc
117: WHERE csi_item_instance_id in ( SELECT object_id
118: FROM csi_ii_relationships
119: START WITH object_id = p_csi_item_instance_id
120: AND relationship_type_code = 'COMPONENT-OF'

Line 130: FROM ahl_unit_config_headers uc

126:
127: -- For top node.
128: CURSOR get_unit_name_csr1 (p_csi_item_instance_id IN NUMBER) IS
129: SELECT name
130: FROM ahl_unit_config_headers uc
131: WHERE csi_item_instance_id = p_csi_item_instance_id
132: and unit_config_status_code = 'COMPLETE' and (active_end_date is null or active_end_date > sysdate);
133:
134: l_name ahl_unit_config_headers.name%TYPE;

Line 134: l_name ahl_unit_config_headers.name%TYPE;

130: FROM ahl_unit_config_headers uc
131: WHERE csi_item_instance_id = p_csi_item_instance_id
132: and unit_config_status_code = 'COMPLETE' and (active_end_date is null or active_end_date > sysdate);
133:
134: l_name ahl_unit_config_headers.name%TYPE;
135:
136: BEGIN
137: --Check for top node.
138: OPEN get_unit_name_csr1(p_csi_item_instance_id);