DBA Data[Home] [Help]

APPS.ZPB_SECURITY_UTIL_PVT SQL Statements

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

Line: 169

select max(has_read_access) into l_read_acc
  from zpb_account_states
   where user_id = p_user_id
   and business_area_id = p_business_area_id;
Line: 292

              update ZPB_ACCOUNT_STATES
                set has_read_access = l_readAcc
                where user_id = p_user_id;