APPS.PRP_GROUP_TOKENS_PKG SQL Statements

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

Line: 20

  CURSOR c(c_group_token_id NUMBER) IS SELECT rowid FROM prp_group_tokens
    WHERE group_token_id = c_group_token_id;

Line: 27

  UPDATE prp_group_tokens SET
    object_version_number = p_object_version_number,
    group_id = p_group_id,
    token_id = p_token_id,
    last_update_date = sysdate,
    last_updated_by = l_user_id,
    last_update_login = l_login_id
    WHERE group_token_id = p_group_token_id;

Line: 38

    INSERT INTO prp_group_tokens
      (
      group_token_id,
      object_version_number,
      group_id,
      token_id,
      creation_date,
      created_by,
      last_update_date,
      last_updated_by,
      last_update_login
      )
      VALUES
      (
      p_group_token_id,
      p_object_version_number,
      p_group_id,
      p_token_id,
      sysdate,
      l_user_id,
      sysdate,
      l_user_id,
      l_login_id
      );