DBA Data[Home] [Help]

APPS.BISM_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

select sys_guid() into oid from dual;
Line: 16

select sys_context('userenv','session_user') into user from dual;
Line: 37

select object_id into oid from bism_objects where folder_id = '30' and object_name = 'ROOT' and user_visible = 'Y';
Line: 45

select subject_id into sub_id from bism_subjects where subject_name = user ;
Line: 59

select privilege into priv from bism_permissions where subject_id=sub_id and object_id='31';
Line: 81

select sys_guid() into oid from dual;
Line: 85

select sysdate into current_time from dual;
Line: 96

select sysdate into current_time from dual;
Line: 101

select sys_guid() into oid from dual;