DBA Data[Home] [Help]

APPS.AME_MULTI_TENANCY_PKG dependencies on AME_MANDATORY_ATTRIBUTES

Line 1301: from ame_mandatory_attributes

1297: ,ame_attributes atr
1298: where seed.attribute_id = atr.attribute_id
1299: and exists
1300: (select null
1301: from ame_mandatory_attributes
1302: where attribute_id = atr.attribute_id
1303: and action_type_id = -1
1304: and sysdate between start_date and nvl(end_Date,sysdate))
1305: and seed.application_id = g_seed_appl_id

Line 1323: from ame_mandatory_attributes

1319: and sysdate between atr.start_Date and nvl(atr.end_Date,sysdate)
1320: and sysdate between atu.start_date and nvl(atu.end_Date,sysdate)
1321: and not exists
1322: (select null
1323: from ame_mandatory_attributes
1324: where attribute_id = atr.attribute_id
1325: and action_type_id = -1
1326: and sysdate between start_Date and nvl(end_Date,sysdate));
1327: fetch seed_row bulk collect into g_seed_attr_usg;