APPS.WF_DIRECTORY_PART_UTIL SQL Statements

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

Line: 21

  select NAME
    from WF_ROLE_LOV_VL
   where DISPLAY_NAME = p_display_name
   order by status, start_date;

Line: 30

   ** used the LOV to select the name and then blanked out the display
   ** name then make sure here to blank out the insternal name and return
   */
   if (p_display_name is null) then

      p_user_name := NULL;

Line: 106

         ** used the lov to select the name in which case the combination
         ** of the display name and the user name should be unique
         */
         if (r_name_lov%ROWCOUNT > 1) then
            close r_name_lov;

Line: 116

             select count(1)
               into l_names_count
               from WF_ROLES
              where NAME = p_user_name
                and ORIG_SYSTEM not in ('HZ_PARTY','POS','ENG_LIST','AMV_CHN',
                                        'HZ_GROUP','CUST_CONT')
                and DISPLAY_NAME = p_display_name;

Line: 136

              select count(1)
                into l_names_count
                from WF_ROLES
               where NAME = p_user_name
                 and ORIG_SYSTEM    = substr(p_user_name, 1, l_colon-1)
                 and ORIG_SYSTEM_ID = l_orig_system_id
                 and DISPLAY_NAME = p_display_name;