DBA Data[Home] [Help]

APPS.AMW_VIOLATION_PVT dependencies on FND_OBJECTS

Line 3100: fnd_objects obj

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
3104: AND DELETION_APPROVAL_DATE IS NULL

Line 3123: fnd_objects obj

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
3127: AND DELETION_APPROVAL_DATE IS NULL