DBA Data[Home] [Help]

APPS.ITA_NOTIFICATION_PKG dependencies on FND_GRANTS

Line 179: FND_GRANTS grants,

175:
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

Line 197: FND_GRANTS grants,

193:
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

Line 214: FND_GRANTS grants,

210:
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