DBA Data[Home] [Help]

APPS.AMW_VIOLATION_PVT dependencies on FND_MENUS

Line 3099: fnd_menus granted_menu,

3095: CURSOR C_Proc_Owner(l_cont_id in NUMBER) IS
3096: SELECT distinct TO_NUMBER(REPLACE(grants.grantee_key,'HZ_PARTY:','')) party_id
3097: FROM AMW_control_Associations ca,
3098: fnd_grants grants,
3099: fnd_menus granted_menu,
3100: fnd_objects obj
3101: WHERE CONTROL_ID = l_cont_id
3102: AND OBJECT_TYPE ='RISK'
3103: AND APPROVAL_DATE IS NOT NULL

Line 3122: fnd_menus granted_menu,

3118: UNION
3119: SELECT distinct TO_NUMBER(REPLACE(grants.grantee_key,'HZ_PARTY:','')) party_id
3120: FROM AMW_control_Associations ca,
3121: fnd_grants grants,
3122: fnd_menus granted_menu,
3123: fnd_objects obj
3124: WHERE CONTROL_ID = l_cont_id
3125: AND OBJECT_TYPE ='RISK_ORG'
3126: AND APPROVAL_DATE IS NOT NULL