867: AND MODEL.object_type = 'PRJ'
868: AND parent.devl_project_id IN
869: (SELECT DISTINCT component_id FROM cz_model_ref_expls
870: WHERE deleted_flag = '0' AND model_id = p_component_id
871: AND (ps_node_type = CZ_TYPES.PS_NODE_TYPE_REFERENCE
872: OR ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_MODEL))
873: AND PARENT.ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_OPTION_CLASS
874: AND PARENT.effective_until > SYSDATE
875: AND NOT EXISTS
868: AND parent.devl_project_id IN
869: (SELECT DISTINCT component_id FROM cz_model_ref_expls
870: WHERE deleted_flag = '0' AND model_id = p_component_id
871: AND (ps_node_type = CZ_TYPES.PS_NODE_TYPE_REFERENCE
872: OR ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_MODEL))
873: AND PARENT.ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_OPTION_CLASS
874: AND PARENT.effective_until > SYSDATE
875: AND NOT EXISTS
876: (SELECT 1 FROM cz_ps_nodes CHILD
869: (SELECT DISTINCT component_id FROM cz_model_ref_expls
870: WHERE deleted_flag = '0' AND model_id = p_component_id
871: AND (ps_node_type = CZ_TYPES.PS_NODE_TYPE_REFERENCE
872: OR ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_MODEL))
873: AND PARENT.ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_OPTION_CLASS
874: AND PARENT.effective_until > SYSDATE
875: AND NOT EXISTS
876: (SELECT 1 FROM cz_ps_nodes CHILD
877: WHERE CHILD.deleted_flag = '0'