APPS.IRC_VCE_SHD SQL Statements

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

Line: 60

    select
       vacancy_id
      ,variable_comp_lookup
      ,object_version_number
    from        irc_variable_comp_elements
    where       vacancy_id = p_vacancy_id
    and   variable_comp_lookup = p_variable_comp_lookup;

Line: 131

    select
       vacancy_id
      ,variable_comp_lookup
      ,object_version_number
    from        irc_variable_comp_elements
    where       vacancy_id = p_vacancy_id
    and   variable_comp_lookup = p_variable_comp_lookup
    for update nowait;