DBA Data[Home] [Help]

APPS.AME_MULTI_TENANCY_PKG dependencies on AME_ATTRIBUTES

Line 1297: ,ame_attributes atr

1293: logMessage(l_proc_name,'Reading mandatory attribute usage data');
1294: open seed_row for
1295: select seed.*
1296: from ame_attribute_usages seed
1297: ,ame_attributes atr
1298: where seed.attribute_id = atr.attribute_id
1299: and exists
1300: (select null
1301: from ame_mandatory_attributes

Line 1315: from ame_attributes atr

1311: --+
1312: logMessage(l_proc_name,'Reading Transaction Type Attribute Usage data');
1313: open seed_row for
1314: select atu.*
1315: from ame_attributes atr
1316: ,ame_attribute_usages atu
1317: where atr.attribute_id = atu.attribute_id
1318: and atu.application_id = g_seed_appl_id
1319: and sysdate between atr.start_Date and nvl(atr.end_Date,sysdate)