APPS.IRC_RAV_SHD SQL Statements

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

Line: 59

    select
       vac_rec_area_id
      ,vacancy_id
      ,hierarchy_version_id
      ,hierarchy_name
      ,object_version_number
    from        irc_vac_rec_area_values
    where       vac_rec_area_id = p_vac_rec_area_id;

Line: 129

    select
       vac_rec_area_id
      ,vacancy_id
      ,hierarchy_version_id
      ,hierarchy_name
      ,object_version_number
    from        irc_vac_rec_area_values
    where       vac_rec_area_id = p_vac_rec_area_id
    for update nowait;