DBA Data[Home] [Help]

APPS.AME_APPROVER_DEVIATION_PKG dependencies on AME_ATTRIBUTES

Line 95: ,ame_attributes attr

91: cursor getAttributeDetails(applnIdIn in number) is
92: select is_static
93: ,query_string
94: from ame_attribute_usages atu
95: ,ame_attributes attr
96: where attr.name = 'DESCRIPTION_OF_TRANSACTION'
97: and attr.attribute_id = atu.attribute_id
98: and application_id = applnIdIn
99: and sysdate between attr.start_date and nvl(attr.end_date,sysdate)