APPS.IBY_DEFAULT_BEP_PKG SQL Statements

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

Line: 15

  SELECT *
    FROM iby_default_bep  a
    WHERE
      i_version = a.object_version_number AND
      i_instrtype = a.instrtype
    FOR UPDATE;

Line: 42

  UPDATE iby_default_bep
    SET
      instrtype = i_instrtype,
      bepid = i_bepid,
      last_update_date = sysdate,
      last_updated_by = fnd_global.user_id,
      last_update_login = fnd_global.login_id,
      object_version_number = object_version_number+1
    WHERE CURRENT OF c_defaultBep;