[Home] [Help]
470: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1));
471: --
472: --Get all of the unit's instances/positions that are NOT extra nodes
473: CURSOR get_unit_tree_csr(c_csi_instance_id IN NUMBER) IS
474: SELECT c_csi_instance_id FROM dual
475: UNION ALL
476: SELECT subject_id
477: FROM csi_ii_relationships
478: START WITH object_id = c_csi_instance_id
688: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1));
689: --
690: --Get all of the unit's instances/positions. Get all non-extra nodes
691: CURSOR get_unit_tree_csr(c_csi_instance_id IN NUMBER) IS
692: SELECT c_csi_instance_id FROM dual
693: UNION ALL
694: SELECT subject_id
695: FROM csi_ii_relationships
696: START WITH object_id = c_csi_instance_id
1138:
1139: -- Get all leaf non-extra nodes and do not get sub-config root nodes, as these do not need the position quantity validation.
1140: -- Also such instances are inflection points for which get_pos_dtls_csr will not return any records.
1141: CURSOR get_unit_tree_csr(c_csi_instance_id IN NUMBER) IS
1142: SELECT c_csi_instance_id FROM dual
1143: WHERE NOT EXISTS (SELECT 1
1144: FROM csi_ii_relationships
1145: WHERE object_id = c_csi_instance_id
1146: AND relationship_type_code = 'COMPONENT-OF'
1473:
1474: -- Get all leaf non-extra nodes and do not get sub-config root nodes, as these do not need the position quantity validation.
1475: -- Also such instances are inflection points for which get_pos_dtls_csr will not return any records.
1476: CURSOR get_unit_tree_csr(c_csi_instance_id IN NUMBER) IS
1477: SELECT c_csi_instance_id FROM dual
1478: WHERE NOT EXISTS (SELECT 1
1479: FROM csi_ii_relationships
1480: WHERE object_id = c_csi_instance_id
1481: AND relationship_type_code = 'COMPONENT-OF'