DBA Data[Home] [Help]

APPS.BSC_UPGRADES_GENERIC dependencies on FND_OBJECTS

Line 93: SELECT OBJECT_ID into l_object_id FROM FND_OBJECTS WHERE OBJ_NAME = l_object_name;

89: l_instance_type := 'INSTANCE';
90: l_grantee_type := 'USER';
91: l_bsc_program_name := 'BSC_PMD_GRANTS';
92:
93: SELECT OBJECT_ID into l_object_id FROM FND_OBJECTS WHERE OBJ_NAME = l_object_name;
94:
95: -- clear all records from fnd_grants
96: DELETE FROM FND_GRANTS WHERE OBJECT_ID = to_char(l_object_id)
97: AND PROGRAM_NAME = 'BSC_PMD_GRANTS';