[Home] [Help]
469: CURSOR l_csi_iea_values_ins_csr(p_instance_id IN NUMBER)
470: IS
471: SELECT attrval.attribute_value_id
472: FROM csi_iea_values attrval,
473: csi_i_extended_attribs attr
474: WHERE attrval.instance_id = p_instance_id
475: AND attrval.attribute_id = attr.attribute_id
476: AND SYSDATE BETWEEN NVL(attrval.active_start_date, SYSDATE) AND NVL(attrval.active_end_date, SYSDATE)
477: AND SYSDATE BETWEEN NVL(attr.active_start_date, SYSDATE) AND NVL(attr.active_end_date, SYSDATE)
739: CURSOR l_csi_iea_values_del_csr(p_instance_id IN NUMBER)
740: IS
741: SELECT attrval.attribute_value_id
742: FROM csi_iea_values attrval,
743: csi_i_extended_attribs attr
744: WHERE attrval.instance_id = p_instance_id
745: AND attrval.attribute_id = attr.attribute_id
746: AND EXISTS(SELECT 1 FROM CSM_CSI_ITEM_ATTR_ACC acc
747: WHERE acc.attribute_value_id = attrval.attribute_value_id