APPS.HR_AVM_SHD SQL Statements

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

Line: 48

    select
       ath_dsn
      ,ath_tablename
      ,ath_columnname
      ,ath_varname
      ,object_version_number
      ,ath_variablemap_id
    from        hr_ath_variablemap
    where       ath_variablemap_id = p_ath_variablemap_id;

Line: 119

    select
       ath_variablemap_id
      ,ath_dsn
      ,ath_tablename
      ,ath_columnname
      ,ath_varname
      ,object_version_number

    from        hr_ath_variablemap
    where       ath_variablemap_id = p_ath_variablemap_id
    for update nowait;