4505: select
4506: to_char(ame_attributes.start_date) start_date
4507: from
4508: ame_attributes,
4509: ame_mandatory_attributes
4510: where
4511: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
4512: ame_attributes.attribute_id = attributeIdIn and
4513: ame_mandatory_attributes.action_type_id = -1 and
4507: from
4508: ame_attributes,
4509: ame_mandatory_attributes
4510: where
4511: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
4512: ame_attributes.attribute_id = attributeIdIn and
4513: ame_mandatory_attributes.action_type_id = -1 and
4514: sysdate between ame_attributes.start_date and
4515: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
4509: ame_mandatory_attributes
4510: where
4511: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
4512: ame_attributes.attribute_id = attributeIdIn and
4513: ame_mandatory_attributes.action_type_id = -1 and
4514: sysdate between ame_attributes.start_date and
4515: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
4516: sysdate between ame_mandatory_attributes.start_date and
4517: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
4512: ame_attributes.attribute_id = attributeIdIn and
4513: ame_mandatory_attributes.action_type_id = -1 and
4514: sysdate between ame_attributes.start_date and
4515: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
4516: sysdate between ame_mandatory_attributes.start_date and
4517: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
4518: for update;
4519: actionTypeIds ame_util.idList;
4520: applicationId integer;
4513: ame_mandatory_attributes.action_type_id = -1 and
4514: sysdate between ame_attributes.start_date and
4515: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
4516: sysdate between ame_mandatory_attributes.start_date and
4517: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
4518: for update;
4519: actionTypeIds ame_util.idList;
4520: applicationId integer;
4521: attributeCount integer;