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