APPS.AHL_MR_LOOP_CHAIN_RELNS_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 832: FROM ahl_unit_config_headers

828: IS
829: -- Get ucHeader for component
830: CURSOR get_unit_name_com (p_item_instance_id IN NUMBER) IS
831: SELECT unit_config_header_id, name
832: FROM ahl_unit_config_headers
833: WHERE csi_item_instance_id IN ( SELECT object_id
834: FROM csi_ii_relationships
835: START WITH subject_id = p_item_instance_id
836: AND relationship_type_code = 'COMPONENT-OF'

Line 850: FROM ahl_unit_config_headers

846:
847: -- Get ucHeader for top node
848: CURSOR get_unit_name_top (p_item_instance_id IN NUMBER) IS
849: SELECT unit_config_header_id, name
850: FROM ahl_unit_config_headers
851: WHERE csi_item_instance_id = p_item_instance_id
852: AND sysdate between trunc(nvl(active_start_date,sysdate))
853: AND trunc(nvl(active_end_date, SYSDATE+1));
854: