DBA Data[Home] [Help]

APPS.ITA_NOTIFICATION_PKG dependencies on FND_OBJECTS

Line 180: FND_OBJECTS objects,

176: cursor GET_OWNER_RISK_ORG(p_org_id NUMBER, p_process_id NUMBER) is
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

Line 198: FND_OBJECTS objects,

194: cursor GET_OWNER_RISK(p_process_id NUMBER) is
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

Line 215: FND_OBJECTS objects,

211: cursor GET_OWNER_ORG(p_org_id NUMBER) is
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