DBA Data[Home] [Help]

APPS.ITA_NOTIFICATION_PKG dependencies on FND_MENUS

Line 181: FND_MENUS menus

177: select distinct to_number(replace(grants.GRANTEE_KEY, 'HZ_PARTY:', '')) owner_id
178: from
179: FND_GRANTS grants,
180: FND_OBJECTS objects,
181: FND_MENUS menus
182: where
183: objects.OBJ_NAME = 'AMW_PROCESS_ORGANIZATION' and
184: grants.OBJECT_ID = objects.OBJECT_ID and
185: grants.GRANTEE_TYPE = 'USER' and

Line 199: FND_MENUS menus

195: select distinct to_number(replace(grants.GRANTEE_KEY, 'HZ_PARTY:', '')) owner_id
196: from
197: FND_GRANTS grants,
198: FND_OBJECTS objects,
199: FND_MENUS menus
200: where
201: objects.OBJ_NAME = 'AMW_PROCESS_APPR_ETTY' and
202: grants.OBJECT_ID = objects.OBJECT_ID and
203: grants.GRANTEE_TYPE = 'USER' and

Line 216: FND_MENUS menus

212: select distinct to_number(replace(grants.GRANTEE_KEY, 'HZ_PARTY:', '')) owner_id
213: from
214: FND_GRANTS grants,
215: FND_OBJECTS objects,
216: FND_MENUS menus
217: where
218: objects.OBJ_NAME = 'AMW_ORGANIZATION' and
219: grants.OBJECT_ID = objects.OBJECT_ID and
220: grants.GRANTEE_TYPE = 'USER' and