APPS.AMW_PROCCERT_REMINDER_PKG dependencies on FND_GRANTS

Line 39: from fnd_grants grants,

35: RETURN NUMBER
36: IS
37: CURSOR C_Proc_Owner IS
38: select TO_NUMBER(REPLACE(grants.grantee_key,'HZ_PARTY:',''))
39: from fnd_grants grants,
40: fnd_objects obj,
41: fnd_menus granted_menu
42: where obj.obj_name = 'AMW_PROCESS_ORGANIZATION'
43: AND grants.object_id = obj.object_id

Line 63: from fnd_grants grants,

59: and process_id = p_process_id;
60:
61: CURSOR C_Org_Owner IS
62: select TO_NUMBER(REPLACE(grants.grantee_key,'HZ_PARTY:',''))
63: from fnd_grants grants,
64: fnd_objects obj,
65: fnd_menus granted_menu
66: where obj.obj_name = 'AMW_ORGANIZATION'
67: AND grants.object_id = obj.object_id

Line 138: FROM fnd_grants grants,

134:
135: PROCEDURE get_proc_ownerlist(p_certification_id IN NUMBER, p_organization_id IN NUMBER, p_process_id IN NUMBER) IS
136: CURSOR c_proc_owner IS
137: SELECT to_number(REPLACE(grants.grantee_key, 'HZ_PARTY:', '')) process_owner_id
138: FROM fnd_grants grants,
139: fnd_objects obj,
140: fnd_menus granted_menu
141: WHERE obj.obj_name = 'AMW_PROCESS_ORGANIZATION'
142: AND grants.object_id = obj.object_id

Line 162: FROM fnd_grants grants,

158: AND process_id = p_process_id;
159:
160: CURSOR c_org_owner IS
161: SELECT to_number(REPLACE(grants.grantee_key, 'HZ_PARTY:', '')) org_owner_id
162: FROM fnd_grants grants,
163: fnd_objects obj,
164: fnd_menus granted_menu
165: WHERE obj.obj_name = 'AMW_ORGANIZATION'
166: AND grants.object_id = obj.object_id

Line 511: fnd_grants grants,

507: select distinct
508: TO_NUMBER(REPLACE(grants.grantee_key,'HZ_PARTY:',''))
509: process_owner_id
510: from amw_execution_scope exscope,
511: fnd_grants grants,
512: fnd_objects obj,
513: fnd_menus granted_menu
514: where exscope.ENTITY_TYPE = 'BUSIPROC_CERTIFICATION'
515: and exscope.ENTITY_ID = p_entity_id