DBA Data[Home] [Help]

APPS.AME_TEST_UTILITY_PKG dependencies on AME_MANDATORY_ATTRIBUTES

Line 595: (select attribute_id from ame_mandatory_attributes

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

Line 597: sysdate between ame_mandatory_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

Line 598: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) ) 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