DBA Data[Home] [Help]

APPS.AMW_VIOLATION_PVT dependencies on AMW_CONTROL_ASSOCIATIONS

Line 3097: FROM AMW_control_Associations ca,

3093: -- A Control is associated a Constraint. So get the process owners of all the process
3094: -- that uses this control to mitigate the associated risk.
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

Line 3120: FROM AMW_control_Associations ca,

3116: AND grants.instance_pk5_value = '*NULL*'
3117: AND granted_menu.menu_name = 'AMW_RL_PROC_OWNER_ROLE'
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