function getAppEvents($APP_UID, $DEL_INDEX)
{
//for single task event
$oCriteria = new Criteria('workflow');
$oCriteria->addSelectColumn(AppEventPeer::APP_UID);
$oCriteria->addSelectColumn(AppEventPeer::DEL_INDEX);
$oCriteria->addSelectColumn(AppEventPeer::EVN_UID);
$oCriteria->addSelectColumn(AppEventPeer::APP_EVN_ACTION_DATE);
$oCriteria->addSelectColumn(AppEventPeer::APP_EVN_ATTEMPTS);
$oCriteria->addSelectColumn(AppEventPeer::APP_EVN_LAST_EXECUTION_DATE);
$oCriteria->addSelectColumn(AppEventPeer::APP_EVN_STATUS);
$oCriteria->addSelectColumn(EventPeer::EVN_UID);
$oCriteria->addSelectColumn(EventPeer::PRO_UID);
$oCriteria->addSelectColumn(EventPeer::EVN_STATUS);
$oCriteria->addSelectColumn(EventPeer::EVN_WHEN_OCCURS);
$oCriteria->addSelectColumn(EventPeer::EVN_RELATED_TO);
$oCriteria->addSelectColumn(EventPeer::TAS_UID);
$oCriteria->addSelectColumn(EventPeer::EVN_TAS_UID_FROM);
$oCriteria->addSelectColumn(EventPeer::EVN_TAS_UID_TO);
$oCriteria->addSelectColumn(EventPeer::EVN_TAS_ESTIMATED_DURATION);
$oCriteria->addSelectColumn(EventPeer::EVN_WHEN);
$oCriteria->addSelectColumn(EventPeer::EVN_MAX_ATTEMPTS);
$oCriteria->addSelectColumn(EventPeer::EVN_ACTION);
$oCriteria->addSelectColumn(EventPeer::EVN_CONDITIONS);
$oCriteria->addSelectColumn(EventPeer::EVN_ACTION_PARAMETERS);
$oCriteria->addSelectColumn(EventPeer::TRI_UID);
$oCriteria->addJoin(AppEventPeer::EVN_UID, EventPeer::EVN_UID);
$oCriteria->add(AppEventPeer::APP_UID, $APP_UID);
$oCriteria->add(AppEventPeer::DEL_INDEX, $DEL_INDEX);
$oCriteria->add(AppEventPeer::APP_EVN_STATUS, 'OPEN');
$oDataset = AppEventPeer::doSelectRs($oCriteria);
$oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC);
$aRows = array();
while ($oDataset->next()) {
$aRows[] = $oDataset->getRow();
}
return count($aRows) > 0 ? $aRows : false;
}
