591: ame_item_classes.item_class_id = headerItemClassIdIn and
592: ame_attribute_usages.application_id = applicationIdIn and
593: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and
594: ame_attributes.attribute_id not in
595: (select attribute_id from ame_mandatory_attributes
596: where action_type_id = -1 and
597: sysdate between ame_mandatory_attributes.start_date and
598: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) ) and
599: sysdate between ame_attributes.start_date and
593: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and
594: ame_attributes.attribute_id not in
595: (select attribute_id from ame_mandatory_attributes
596: where action_type_id = -1 and
597: sysdate between ame_mandatory_attributes.start_date and
598: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) ) and
599: sysdate between ame_attributes.start_date and
600: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
601: sysdate between ame_attribute_usages.start_date and
594: ame_attributes.attribute_id not in
595: (select attribute_id from ame_mandatory_attributes
596: where action_type_id = -1 and
597: sysdate between ame_mandatory_attributes.start_date and
598: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) ) and
599: sysdate between ame_attributes.start_date and
600: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
601: sysdate between ame_attribute_usages.start_date and
602: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and